Pivot table layout that popluates the row label in each row?


P

pmacnabb

I am trying find a way to format a pivot table so that it will display the
row label in each row below it instead of at the top in summary form...

This would allow me to do a pivot table agianst a pivot able which is
helpful when your original table is from an OLAP cube that does not have that
same level of functionaility as a regular pivot table.
 
Ad

Advertisements

Ad

Advertisements

1

1whtevr

You can sort of do it.
If you have say 3 fields that you use in the pivot table row, last name,
first name, birthday, you can create a 'key' field in the data that
concatenates the 3 together. Then when you create the pivot have the key
field as the first field in the row order. This allowed me to have each row
populated with the row label, and I just hide the garbage concatenated field.
Hope this helps someone.
 

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

Top