Grouping Dimension values

[former_member229754]

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

[amitrathi239 · Accepted solution]

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]