I wonder whether someone can help me with a PivotTable problem? I have a PivotTable sourced from four columns of data - date, client, service and revenue - which are then displayed in the PivotTable as:
[INDENT]Report filter: service
Row label: client list
Column labels: date
Values: revenue (sum)[/INDENT]
I've attached an example of this done is exactly the same way as the real sheet.
I'd like to be able to use calculated fields certain dates - for example, a total of the last six months or the latest month minus the previous month. However, I can’t seem to find a way to do this without stepping out of the PivotTable and using =GETPIVOTDATA.
This is really a suboptimal way of doing it, as the data has to be showed in a separate sheet oir below (because when the PivotTable is filtered or added to, the 'external' cells referencing it won’t react accordingly.
I don't suppose anyone has any ideas on how to best achieve this?
Apologies in advance if I've posted in the wrong place or missed a previous answer to this query. I wasn't able to find one during extensive searching, but it's possible that my OzGrid-search-fu is weak!
Edit: I guess some more information within the post might help me get an answer? The blue cells below are here being calculated using =GETPIVOTDATA but I'd like to be able to work them out inside the PivotTable if possible.
[Blocked Image: http://i.imgur.com/Eno08.png]