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 the blanks,
using the technique shown he

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

DrIan wrote:
Can anyone tell me if its possible to get excel to put the Group Label
Data on each line in the pivot table ?

So for example where i have following data:

Country,Region,Unit,Amount
UK,North,Sales,100
Uk,North,Sales,50
UK,North,Sales,10
Uk,North,Warehouse,5
Uk,North,Warehouse,10

When i pivot and group Sum of Amount by Country, Region and Unit, what
i get is:

Uk|North|Sales |160
| |Warehouse| 15
Grand total |175

What i would like is with the group displayed on each line?

UK|North|Sales |160
UK|North|Warehouse |15
Grand total |175

Thanks




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html