Hi Xor.
Thanks for your commitment.
Please have a look at the attached file
The first tab "System Layout" shows how the system report
The second tab"NO" is the pivot table generated from the first tab "System Layout". Please observe that everything is messed
The third tab "Layout to Pivot" is how Excel need the information to generate an accurate and correct Pivot table
The fourth tab "YES" is how I would like to have the report. Please observe that here the "products" belong to the right "AC" & "Customer"
So the idea is to have the fourth pivot table from the first one. If is necessary with or without intermediate steps.
Thanks, Adrian
|