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
-Somasundaram
If this resolves your Query please like and accept this as an answer.
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.
