running total (balance) reset on month change in pivot table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shripaldalal - 20 Sep 2007 09:22 GMT

hi,

have a simple question...

how can i reset the running total in pivot table back to zero once the
month changes ?

mar 1 - 2000 - 2000
mar 2 - 3000 - 5000
mar 3 - 5000 - 10000
--------------------------------
apr 1 - 20000 - 20000
apr 2 - 50000 - 70000

that's all.

shripal dalal.

Reply to this Message

Roger Govier - 20 Sep 2007 13:58 GMT

Hi

Right click on your data field and choose Group and Show Detail>Group>select
Months and Days>OK
Then right click on PT>Wizard>Layout>reset your Sum of Value2 to be Running
Total by Date.

Signature

Regards
Roger Govier

> hi,
>
[quoted text clipped - 13 lines]
>
> shripal dalal.

Reply to this Message