Pivotable help

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

How can i create a field that will give me percentage of
the items in another column. for example:

test yes 2
no 1
test total 3

The column with be to the right of these two columns and
give me the percent of 2 and 1 from 100.

Special thanks in advance!
 
Add another copy of the Yes/No field to the data area of the pivot table.
Right-click on the column heading, and choose Field Settings
Click the Options button, and choose to Show Data as % of column
Click OK, and format the column as Percent.
 
Back
Top