LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to show the total in a pivot chart Holly Excel Discussion (Misc queries) 1 August 8th 08 02:42 PM
Pivot chart and Total row rexmann Charts and Charting in Excel 0 March 27th 08 01:42 PM
Showing Pivot Table total on Associated Pivot Chart KenY Excel Discussion (Misc queries) 2 May 18th 07 02:41 PM
Pivot Chart--I want total average, not sum of averages Jason McDermott Charts and Charting in Excel 3 September 1st 06 06:20 PM
Pivot Chart Total Columns Hans Charts and Charting in Excel 3 September 5th 05 02:46 PM


All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"