pivot table formatting

  • Thread starter Thread starter mwam423
  • Start date Start date
M

mwam423

greetings! if i've got three items in the "row" section of pivot table
layout, is it possible to have the value of the first and second items
displayed on each line? the default table currently has the first item on
the first line only, second items will appear once at the top of each of
their sections, then the third item will appear on each line. guessing this
is just how pivot output pops out but you folks can help me find out
definitively.
 
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
 
Back
Top