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 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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Kurt" <[email protected]> wrote in message news:[email protected]...
> 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
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
Kurt wrote:
> 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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks