Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
I am venturing into the world of pivot talbes. Ultimately I would like the
report to be a table that essentially concatentates "n (%)", the number value following by the percentage. Currently, I have 2 pivot tables, they are identical except, one is the count, the other is percentage. I do a paste special onto another worksheet and from there, I can concatenate. This is a lot of work. Any shortcuts? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
To change the appearance of the numbers and show the % sign:
Right-click one of the numbers in the pivot table, and click on Field Settings Click the Number Format button Click Custom Category In the Type box, enter: General"%" Click OK PAL wrote: I am venturing into the world of pivot talbes. Ultimately I would like the report to be a table that essentially concatentates "n (%)", the number value following by the percentage. Currently, I have 2 pivot tables, they are identical except, one is the count, the other is percentage. I do a paste special onto another worksheet and from there, I can concatenate. This is a lot of work. Any shortcuts? Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
Doesn't really address the question of needing both the count and the
percent. Thanks. "Debra Dalgleish" wrote: To change the appearance of the numbers and show the % sign: Right-click one of the numbers in the pivot table, and click on Field Settings Click the Number Format button Click Custom Category In the Type box, enter: General"%" Click OK PAL wrote: I am venturing into the world of pivot talbes. Ultimately I would like the report to be a table that essentially concatentates "n (%)", the number value following by the percentage. Currently, I have 2 pivot tables, they are identical except, one is the count, the other is percentage. I do a paste special onto another worksheet and from there, I can concatenate. This is a lot of work. Any shortcuts? Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
Just drag the field you are trying to sum into the data area. Do this twice.
Then right-click one of the totals, go to options, and show values as % of column. Then format as Debra explained. Ed Ferrero www.edferrero.com "PAL" wrote in message ... Doesn't really address the question of needing both the count and the percent. Thanks. "Debra Dalgleish" wrote: To change the appearance of the numbers and show the % sign: Right-click one of the numbers in the pivot table, and click on Field Settings Click the Number Format button Click Custom Category In the Type box, enter: General"%" Click OK PAL wrote: I am venturing into the world of pivot talbes. Ultimately I would like the report to be a table that essentially concatentates "n (%)", the number value following by the percentage. Currently, I have 2 pivot tables, they are identical except, one is the count, the other is percentage. I do a paste special onto another worksheet and from there, I can concatenate. This is a lot of work. Any shortcuts? Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
When refreshing pivot tables my pivot table chart type changes | 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) |