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


--
DrIan
------------------------------------------------------------------------
DrIan's Profile: http://www.excelforum.com/member.php...o&userid=37191
View this thread: http://www.excelforum.com/showthread...hreadid=569068