Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help calculating tax and total in pivot chart
I have a pivot table that shows charges by user for services we use, but I
also need to add columns to the table that calculate the tax (*.08) and add it to the Grand Total in the pivot table showing the final total, so the results would be something like below Grand Total Tax Total 7386 618 8004 156 13 169 3177 266 3443 is there a way to add these to the pivot table? I'm trying to make the tax and total calculations dynamic so that if the data changes the tax & total would calculate against the new Grand Totals. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help calculating tax and total in pivot chart
Hi,
In the base data sheet (which is the source of the pivot table), add another column for tax which is computed as amount*.08. Ensure that the pivot table's range has this column. Now just drag this column to the pivot table -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Tom" wrote in message ... I have a pivot table that shows charges by user for services we use, but I also need to add columns to the table that calculate the tax (*.08) and add it to the Grand Total in the pivot table showing the final total, so the results would be something like below Grand Total Tax Total 7386 618 8004 156 13 169 3177 266 3443 is there a way to add these to the pivot table? I'm trying to make the tax and total calculations dynamic so that if the data changes the tax & total would calculate against the new Grand Totals. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help calculating tax and total in pivot chart
This adds an auxiliary Table to the Pivot Table.
Tax Table resizes in step with Pivot Table. No added source columns. Includes Grand Tax Total. Includes update macro. http://www.savefile.com/files/1867201 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to show the total in a pivot chart | Excel Discussion (Misc queries) | |||
Pivot chart and Total row | Charts and Charting in Excel | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot Chart--I want total average, not sum of averages | Charts and Charting in Excel | |||
Pivot Chart Total Columns | Charts and Charting in Excel |