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