Pivot tables
 

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

Pivot tables
 

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

Pivot tables
 

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

Pivot tables
 

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