PivotTable - Show labels on every row?

[S Davis]

Hi there,

Is it possible to show pivottable labels on every row displayed?

For instance:

Basic PivotTable default layout:

Item1--XXX
.........--YYY
.........--ZZZ
Item2--XXX
.........--YYY
.........--ZZZ
Item3--XXX
.........--YYY
.........--ZZZ


and I would like to have it show:

Item1--XXX
Item1--YYY
Item1--ZZZ
Item2-XXX
Item2--YYY
....etc...

Reason being I am running a series of pivottables off of each other,
and the default pivottable layout results in my second pivottable
returning the majority of the results under the (blank) label due to
the first column titles not repeating on each row.

Thanks!

 

[Debra Dalgleish]

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill in the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html