ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I do running Totals in a Pivot Table (https://www.excelbanter.com/excel-worksheet-functions/70058-how-do-i-do-running-totals-pivot-table.html)

Pivot Freak

How do I do running Totals in a Pivot Table
 
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

How do I do running Totals in a Pivot Table
 
Add another copy of the data field, and change its field settings, so it
shows a running total. There are instructions he

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


Pivot Freak

How do I do running Totals in a Pivot Table
 
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 he

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




All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com