help calculating tax and total in pivot chart

T

Tom

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.
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
pivot table, grand total no negatives 3
calculating differences in a pivot table 3
Data Grand Total in Pivot Table Row Area 1
Excel 2007 - Pivot Table and Calculated fields? 1
Pivot Table -- Add column to average Grand Total 1
Pivot Table Sub total and totals 4
Help in calculating tax % for Co2 emissions? 5

Top