on 10-26-2023 10:19 AM
Hi all
I have the measure "Sales" and a dimension "Prod_Code".
I want to be able to create a measure where it returns the sales value of all products that begin with "Li".
I cant get it to work does anyone know how to do this?
Thanks
peersbrennanctb
I am not sure how you ant to display it. But you can try below. First create a calculated dimension as shown below. in My example I have taken product starting with MZ
IF(LEFT([d/"SAP_CEP_SALES_PLANNING":SAP_CEP_PRODUCT].[p/ID], 2)="MZ", "MZProduct", [d/"SAP_CEP_SALES_PLANNING":SAP_CEP_PRODUCT])
Secondly create a restricted measure on this calculated dimension as shown below
Output:
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
peersbrennanctb
I have created a calculated dimension to categorize all products starting with MZ in a calculated dimension as MZ products ( first part of solution). This will take care of any new products added also. You can then create restricted measure with this new calculated dimension. Please see the first part of the solution.
Br.
Nikhil
User | Count |
---|---|
74 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.