Pivot Table Views with multiple Values selected

PCRIDE

Well-known Member
Joined
Jan 20, 2008
Messages
892
Hi, I am wondering what creates the following Pivot table view. It seems that the view changes when you start messing with the ordering of the values, and you can never get it back the way it was.

When you have a pivot table with multiple Values in the values box, the pivot table will sometimes display the data in grouping of the months

For example you might have some data like costs per month and you have a 4 month view, in row 1 you have your cost item, then the 3 values in the pivot table might be Cost, Quantity, and GM%. The pivot table may automatically display it grouped by Month, like

January, then as a sub column you would have Cost, Quantity and GM%, then February Cost, Quantity and GM%, then March Cost, Quantity and GM% etc... when fiddling around with the values the pivot table can end up like

January Cost, February Cost, March Cost, then January Quantity, February Quantity, March Quantity, then January GM%, February GM%, March GM%



Is there a setting for this? Seems that its controlled by the Values and what you put in that field for the pivot table.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,707
You need to watch the order of the fields in ROWS/COLUMNS.
Also changing where the SIGMA symbol resides matters too. Excel tries to be helpful....
 

PCRIDE

Well-known Member
Joined
Jan 20, 2008
Messages
892
You need to watch the order of the fields in ROWS/COLUMNS.
Also changing where the SIGMA symbol resides matters too. Excel tries to be helpful....


Does an order matter? I had 2 Values in my pivot table, it was the latter view, then I added a 3rd value and it all switched so I have all 3 values grouped by month.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,109
Messages
5,545,991
Members
410,718
Latest member
ALM1GHTY
Top