help needed with pivot table

[funkymonkUK]

Hi

I got a pivot table which as a whole load of financial data. I have
field at the end called "Amount Outstanding at end of Month", an
another called, "Change in Balance Outstanding". They work perfectly o
monthy data however if I change it to a financial year or to a quarte
what happens is my Grand total is not correct as it sums up all th
data in the field when in fact it should only show the last month whic
is the amount outstanding.

is there a way or a function to get this to work correctly

 

[funkymonkUK]

anbody please help me:rolleyes

 

[SHMUNCY]

I think that what I would do is have a field next to the pivot table fo
that information, and then have it simply link to the information.
believe that might be the easiest way. I will look into it more for yo
though