ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table and running total (https://www.excelbanter.com/excel-discussion-misc-queries/57627-pivot-table-running-total.html)

PaulGG

Pivot table and running total
 
I have a table with Columns: Region, Client, Date, and quantity.
Using a pivot table I want to see per Region the quantity each Clients
bought or sold.
The problem I have is I can't figure out how to view a running total per
region.
You can view at this URL "http://members.freemail.ch/paulg/pivottable.gif"
a picture of how I would want to see it (in yellow) and the table it comes
from.
Actual data has at least 20 different regions and 60 or so clients.
Any help greatly appreciated.
Thanks


All times are GMT +1. The time now is 05:21 AM.

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