Pivot Tables

[PAL]

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]

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]

Doesn't really address the question of needing both the count and the
percent. Thanks.

 

[Ed Ferrero]

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