Excel 2002 Pivot Tables

[vaneagle]

Hi All,

Any idea how to get the data to repeat itself when using pivot tables?

eg...

Sum of Qty
Type Variant Total
Fruit Apples 4
Orange 3
Pears 5
Fruit Total 12
Vegetables Carrots 5
Peas 7
Potatoes 6
Vegetables Total 18
Grand Total 30

In other words getting "Fruit" and "Vegetables" to repeat on the lines
below..

Any ideas?

 

[Dave Peterson]

Not and keep that pivottable as a pivottable.

You could convert it to values (or copy to a new sheet and do it there and keep
the pivottable alive), then manipulate the data the way you want.

Debra Dalgleish shows a nice way to fill those cells:
http://www.contextures.com/xlDataEntry02.html