I need to have running totals in a pivot table. eg:
Computech FNB
June 100 50
100 50
July 300 60
400 110
August 100 100
500 210
I need to have running totals in a pivot table. eg:
Computech FNB
June 100 50
100 50
July 300 60
400 110
August 100 100
500 210
Add another copy of the data field, and change its field settings, so it
shows a running total. There are instructions here:
http://www.contextures.com/xlPivot10.html
Pivot Freak wrote:
> I need to have running totals in a pivot table. eg:
> Computech FNB
> June 100 50
> 100 50
> July 300 60
> 400 110
> August 100 100
> 500 210
>
>
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Thanks will try...
"Debra Dalgleish" wrote:
> Add another copy of the data field, and change its field settings, so it
> shows a running total. There are instructions here:
>
> http://www.contextures.com/xlPivot10.html
>
> Pivot Freak wrote:
> > I need to have running totals in a pivot table. eg:
> > Computech FNB
> > June 100 50
> > 100 50
> > July 300 60
> > 400 110
> > August 100 100
> > 500 210
> >
> >
> >
> >
>
>
> --
> 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