D
DrIan
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
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