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.

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.

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