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.
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.
