Yes, you can drag another copy of the employee count field from the
field list, into the data area. By default, it should show the Sum of
employee count.

Pascale wrote:
Thank-you that did it, now is it possible to have both columns in my pivot
table, that is to have the head count and to ad the % COLUMN BESIDE IT.

Best regards

"Debra Dalgleish" wrote:


Right-click on a cell that contains one of the head counts.
Click on Field Settings
Click the Options button
Under 'Show data as', select % of column.
Click OK

Pascale wrote:

Hello.

I have these pivot tables in this file, they give me a head count of
employess in a departement. How can I get these head counts to be given to
me by %.

Thank you


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html