Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |