Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table and running total
You could do a running total using Client as the Base field, to run the
total vertically, per client. The grand total for Rows would show the overall running total. PaulGG wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table and running total
Thanks for the suggestion but I want the grand total for columns to show the
overall running total. i.e. per month. Is there any way to do this? "Debra Dalgleish" wrote: You could do a running total using Client as the Base field, to run the total vertically, per client. The grand total for Rows would show the overall running total. PaulGG wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Discussion (Misc queries) | |||
% of running total in pivot table | Excel Discussion (Misc queries) | |||
Group Field in Pivot Table €“ Not Enough Room | Excel Discussion (Misc queries) | |||
Pivot Table - Running Total Annualised | Excel Discussion (Misc queries) | |||
Pivot table (Running Averages) | Excel Worksheet Functions |