Skip to Content
0
Jul 24, 2016 at 08:31 AM

Grouping Dimension values

30 Views

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