| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - Group Label on each line
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot tables - Group Label on each line
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot tables - Group Label on each line
Thanks for the link the Example macro works a treat..very handy -- DrIan ------------------------------------------------------------------------ DrIan's Profile: http://www.excelforum.com/member.php...o&userid=37191 View this thread: http://www.excelforum.com/showthread...hreadid=569068 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot tables - Group Label on each line
You're welcome! Thanks for letting me know that the example helped.
DrIan wrote: Thanks for the link the Example macro works a treat..very handy -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table reports - repeat the group name on each line | Excel Discussion (Misc queries) | |||
| Pivot table to calc by group | Excel Discussion (Misc queries) | |||
| Pivot Tables: Unable to Group and Show Detail | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
Hybrid Mode
