PivotTable calculated fields on non-field columns

  • Hi all,

    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]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!