Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |