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.

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

Hi

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

--
Regards
Roger Govier

"pmacnabb" wrote in message
...
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.

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.

"pmacnabb" wrote:

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.