Accumulating Values in a Pivot table

  • Thread starter Thread starter Kurt
  • Start date Start date
K

Kurt

Hi all.

Does anybody of you know, how I can show in a Pivot table
accumulated values (example)in each row:

Day Amount Accum. Value
1 50 50
3 75 125
8 105 230
.. .. ..
.. .. ..

and so on.

Maybe someone give me a tip.

Thanx a lot

Regards Kurt
 
Hi Kurt,
That is one of the big advantages of using Pivot Tables
One place to start would be
Debra Dalgleish's Contextures.com/techtip.html

http://www.contextures.com/xlPivot05.html

but you would of course start at 01 so you don't miss anything
like a much simpler example. This one has Subtotals that can
be changed depending on what is selected -- way beyond the normal.
 
Add another copy of the Amount field to the pivot table data area
Right-click on the heading for the new field
Choose Field Settings
Click the Options button
From 'Show Data As', select Running Total
For the Base Field, choose Day
Click OK
 
You must log in or register to reply here.

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

How Accumulate the Values? 5
Pivot table filter list - listing irrelevant subcategorys 1
Access #Error & Excel Pivot 0
Pivot Table Set Up 2
Need help 2
including zero values in a pivot table 2
Pivot table and value range 2
How to add a percentage column in a Pivot Table 1

Back
Top