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?
--
vaneagle
------------------------------------------------------------------------
vaneagle's Profile:
http://www.excelforum.com/member.php...nfo&userid=552
View this thread:
http://www.excelforum.com/showthread...hreadid=531775