View Single Post
 
Old 11-08-2017, 04:23 PM
abc3132 abc3132 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2015
Posts: 24
abc3132 is on a distinguished road
Default

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
Attached Files
File Type: xlsx Pivot Table3.xlsx (20.4 KB, 9 views)
Reply With Quote