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

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

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Create a Dynamic Auxiliary Table
with filled in row labels.
Macro.
http://www.mediafire.com/file/j5lmtynwjdj/05_11_09.xlsm

 

[Roger Govier]

Hi

You can't do this.
take a look at Debra Dalgleish's site for a workaround
http://www.contextures.com/xlfaqPivot.html#Repeat

 

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