Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need help.. I have a column (Meet criteria) and the data is 'Yes' or 'No'.
When I do a pivot table, and I drag the field (Meet criteria) as column and values, i will see 'No' and 'Yes' in column with their count. Now I want to do a calculated field or item, that will get the % of 'Yes'/'Grand Total' (Grand Total is the total of 'No + Yes') Pls advise the syntax to capture the value of 'Yes' in (Meet criteria) field. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom field with custom formula in pivot table! | Excel Worksheet Functions | |||
Pivot Table: Custom Formula Question | Excel Discussion (Misc queries) | |||
Pivot Table: Custom formula in data area | Excel Discussion (Misc queries) | |||
Custom Formula in Pivot Table Row | Excel Worksheet Functions | |||
Custom Formula in Pivot Table Row | Charts and Charting in Excel |