Merging Dimension and fact rows

[#1]

Hi,

I have a chart in below format.My requirement is to merge the Pdt2 &Pdt3 in Product dimension and display it as Pdt2 and also the fact values should be summed up together.

Is it possible to do without script changes?

Category	Products	Qty1	Qty2	Qty3
Cat1	Pdt1
	Pdt2
	Pdt3
	Pdt4
Cat2	Pdt1
	Pdt2
	Pdt3
	Pdt4

[johnw · Accepted solution]

You might be able to replace the Products dimension with this:

if(Products='Pdt3','Pdt2',Products)

I think that will combine those two products into one, though I'm not certain.