Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm wondering if it's possible to perform a specific calculation within
a pivot table. Here's the summary: I have a query that returns numeric values in columns called "A," "B," and "C" for each user in a list. The Grand Total column is the sum of A, B, and C for each user. I'm interested in showing the percentage of a user's values belonging to C (e.g. C / SUM(A+B+C)). Is it possible to do this without introducing any sort of additional sheet or helper cells? Thanks for any input. jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Creating Calculations Within a Pivot Table Field | Excel Discussion (Misc queries) | |||
Setting up "Year to Date" Calculations in a Pivot Table | Excel Worksheet Functions | |||
pivot table calculations | Excel Discussion (Misc queries) |