LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 333
Default Pivot Table Sub total and totals

Hi

I have a pivot table wth a field in the column area containing two values,
yes and no. My data is then filterd to these two columns. I have created a
calculated item adding the yes and no for a total people. I created another
calculated field to compute the percentage of 'yes' to the total people. I
have turned off the row grand totals. My column sub totals snd grand totals
are not giving me acurate percentages for the data in the fields. Am I
missing something?
Yes/No
No Yes Total Percentage
Person1
Sub total person1
person2
sub total person2
person3
sub total person3

Thanks for your help in advance.

 
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
Need help with grand totals in pivot table Missygal Excel Discussion (Misc queries) 1 May 16th 06 07:02 PM
Pivot table for reporting sales performance Ram Excel Discussion (Misc queries) 2 February 6th 06 10:06 AM
Incorrect totals in Pivot Table Jake Excel Discussion (Misc queries) 1 January 11th 06 10:58 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Grand Total on Pivot Table turned on but no totals showing GaryRitchie Excel Discussion (Misc queries) 0 June 15th 05 02:13 PM


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