|Subject:||Re: Pivotable help|
|Posted by:||Debra Dalgleish (d…@contexturesXSPAM.com)|
|Date:||Thu, 30 Oct 2003|
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.
> 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!
Excel FAQ, Tips & Book List
Pivotable help posted by Ali on Thu, 30 Oct 2003