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