Re: Pivotable help

Giganews Newsgroups
Subject: Re: Pivotable help
Posted by:  Debra Dalgleish (d…
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.

Ali wrote:
> 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!

Debra Dalgleish
Excel FAQ, Tips & Book List



In response to

Pivotable help posted by Ali on Thu, 30 Oct 2003