Pivot merged dimension

[Somasundaram]

Hi Qlikers,

I would like to recreate the structure shown in the image using a pivot table. The dimension columns are merged, and there are six measures under "Impact Analysis" while "Aggressive" has only three. Is it feasible to achieve this layout in a pivot table?

Month	Sales	Impact analysis						Aggressive
		Adjustment group	# of Sales	% of Sales	% as per adjustment group	$ amount	% of total Sales	# of Dealers at risk	% of Dealers at risk as of total Dealers	% of dealers at risk as of acc. Dealers

[Aditya_Chitale]

Pivot does not work that way. You will have to keep same measures under both dimensions. For Eg. Adjustment Group will show under Aggressive even if it does not have any values. Similarly # of Dealers at Risk will show under Impact Analysis.

You can try looking for extensions. But default Pivot cannot be of much use here.

Regards,

Aditya