View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Davis S Davis is offline
external usenet poster
 
Posts: 138
Default PivotTable - Show labels on every row?

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!