Pivot Tables

P

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

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
 
P

PAL

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top