Tracie has attended:
Excel Advanced course
Pivot tables
Is there a way to use data in Pivot tables so that totals accumilate. e.g. On a monthly/yearly basis?
RE: Pivot tables
Hi Tracie
Thank you for your question. Yes it is possible. Right click on your data field and from the menu choose Field settings. From the Show data as menu select "Running Total in" then choose the Basefield column. This must either be in the row (or column) area rather than the data section of your pivot table e.g. date.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew

