Excel 2002 Pivot Tables
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 |
Excel 2002 Pivot Tables
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 vaneagle wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 02:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com