Unanswered: Month display on pivot, plus variance column
I have a pivot with Month/Yr as the column data, and quite simple HR data in the data area. That data is defined by category which is in the row data area.
Basically, I want to be able to
1. Display the Month/Yr (column data) so that the later month is always to the left of the earlier month. Excel automatically displays it the other way.
2.Insert another column to the right showing the variance between the row data for two months.
Any ideas? Sorry I would have uploaded an image if I'd been able to create one.