Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totalling Columns in Pivot Charts
I have a pivot chart where I brought in data which includes:
Quantity Floor Item # Product Cost Tax Cost Installation Cost I can filter by floor so that I can get totals for each floor, and I can get a total for each item which includes Product Cost + Tax + Installation. I also get a Grand Total which is a sum of the "TOTAL COST" column. But I want a total cost for Product, a total cost for Tax, and a total cost for installation, but can't seem to find the right combination of settings to get those columns which are fields in my data, to total at the bottom. I'm sure I'm missing something very simple, but can't find it. Any help is appreciated. KK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totalling Columns in Pivot Charts
One correction. It's a pivot table, not a pivot chart.
KK "kleivakat" wrote: I have a pivot chart where I brought in data which includes: Quantity Floor Item # Product Cost Tax Cost Installation Cost I can filter by floor so that I can get totals for each floor, and I can get a total for each item which includes Product Cost + Tax + Installation. I also get a Grand Total which is a sum of the "TOTAL COST" column. But I want a total cost for Product, a total cost for Tax, and a total cost for installation, but can't seem to find the right combination of settings to get those columns which are fields in my data, to total at the bottom. I'm sure I'm missing something very simple, but can't find it. Any help is appreciated. KK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching columns, summarizing, and totalling? | Excel Discussion (Misc queries) | |||
How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Totalling values across columns | Excel Worksheet Functions | |||
VBA Code for Matching and totalling columns | Excel Worksheet Functions |