Custom pivot formula

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.
 
D

Daryl S

You can change the display of the counts of Yes and No values to be the
percent of totals. In the pivot table, right-click on the cell with the
count of Yes results, and choose Field Settings. In the PivotTable Field
dialog box that comes up, click the Options button. From the 'Show data as:'
drop-list, choose "% Of".

That will change the counts to percents in your pivot.
 
A

Ashish Mathur

Hi,

Right click on any cell in the data area and select Field settings. Click
on the options button and in the Show as drop down, select % of column

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top