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

To print the table with a heading on each row, you can create a copy of
the table, and fill the blanks:

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



PivotMan wrote:
In a pivot table, if you are summarizing data, the description under LOB (in
the example below)€¦AB,BC and DE are only stored beside the first entry in the
table to the right.


So if you want to use a table to summarize data that can then be used in a
database€¦the labels under LOB for everything other than the first entry in
Product Family are blank€¦

I know that there are ways to fill down€¦but that is not terribly convenient.

I was thinking that there ought to be a Pivot table formatting option..

Here is what I am getting:

Value
LOB Product Family Total
AB D1 976,448
D2 324,995
D3 7,114,802
D4 1,668,533
BC D1 1,921
D2 1,433,820
D3 609,058
D4 2,594,837
DE D1 370,667
D2 514,983
D3 3,230,190
D4 85,735



This is what I want.

Value
LOB Product Family Total
AB D1 976,448
AB D2 324,995
AB D3 7,114,802
AB D4 1,668,533
BC D1 1,921
BC D2 1,433,820
BC D3 609,058
BC D4 2,594,837
DE D1 370,667
DE D2 514,983
DE D3 3,230,190
DE D4 8,838


Any insight would be greatly appreciated.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html