Pivot tables

P

Pascale

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
 
D

Debra Dalgleish

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
 
P

Pascale

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
 
D

Debra Dalgleish

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