|
|
#7
11-08-2017, 04:23 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table - Copy Rows | theexpat | Excel Programming | 0 | 02-26-2016 08:14 AM |
 Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
| Average over all pivot rows in excel | Andrey | Excel | 2 | 07-23-2014 07:51 AM |
|
Grouping table rows to prevent individual rows from breaking across pages
|
dennist77 | Word | 1 | 10-29-2013 11:39 PM |
| Excel Pivot - Do not display rows with zero value | patidallas22 | Excel | 1 | 03-08-2013 01:35 PM |
Windows 7 64bit 
Office 2007
Threaded Mode