Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Incorrect totals in Pivot Table | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Grand Total on Pivot Table turned on but no totals showing | Excel Discussion (Misc queries) |