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

S

shripaldalal

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.
 
R

Roger Govier

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
monthly opening and closing balance in pivot table 4
excel - running total in pivot table 0
populating monthly costs in excel sheets... 3
running balance in pivot table 0
Running Balance in excel pivot table 0
calculating inflows in each month depending on different paymentterms 1
Problem: Running Total in Pivot Table 0

Top