I'm sure this is really simple but I can't figure it out. I want to display a quarterly revenue variance in a pivot table, but the quarters I want to compare are in the same column in the source data (labelled 'Qtr').
I can add a second Revenue field under values and use 'Show Values As..', but then I end up with superfluous empty column which I don't want. Think I'm approaching this in totally the wrong way. Any help is greatly appreciated.
Capture.PNG
Bookmarks