LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jim
 
Posts: n/a
Default Pivot Table Calculations

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
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
Excel 2k Pivot Table refresh scenario GDCross Excel Discussion (Misc queries) 1 June 1st 06 09:12 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Creating Calculations Within a Pivot Table Field MinhPhan Excel Discussion (Misc queries) 0 March 27th 05 05:57 PM
Setting up "Year to Date" Calculations in a Pivot Table Project64 Excel Worksheet Functions 1 March 22nd 05 01:50 AM
pivot table calculations Joe S. Excel Discussion (Misc queries) 1 December 9th 04 07:46 PM


All times are GMT +1. The time now is 02:16 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"