X
xiaohui
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.
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.