Dear All,
I've getting this kind of challenge
I have a dimension Product with their values
Product_1 = 1000
Product_2 = 500
Product_3 = 2000
Product_4 = 5000
I want to design a report with this combination (manual)
Product_TypeA = Product_1 + Product_3 = 1000+2000 = 3000
Product_TypeB = Product_1 + Product_4 = 1000+5000 = 6000
Product_typeC = Product_2 = 500
Reports output should be:
Product_TypeA = 3000
Product_TypeB = 6000
Product TypeC = 500
is there anyway i can achieve this?
Thanjks
try with these steps.
First Create variable Product Type=If([Product] InList("Product_1";"Product_3")) Then "Product_TypeA" ElseIf([Product] InList("Product_1";"Product_4")) Then "Product_TypeB" Else "Product_TypeC"
For value create variable=If([Product Type]="Product_TypeB") Then [Value]+ [Value] Where ([Product] InList ("Product_1")) In Report Else [Value]
Add a comment