| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot
I have the following Pivot Table:
Shipper KGS Alfa 1050 Bravo 2010 Charlie 960 Is it possible to only show the Pivot as this: Shipper KGS Alfa 1050 Bravo(+Charlie) 2970 Please JPG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot
Select both Bravo and Charlie (the text) and right-click and select Group and
show Detail/Group. You will see the name Group1 which you can type over and enter Bravo(+Charlie) or whatever you like. Then you can drag the title KGS away (out of the pivot table). Bob Umlas Excel MVP "juanpablo" wrote: I have the following Pivot Table: Shipper KGS Alfa 1050 Bravo 2010 Charlie 960 Is it possible to only show the Pivot as this: Shipper KGS Alfa 1050 Bravo(+Charlie) 2970 Please JPG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot
Thank you very much.
"Bob Umlas, Excel MVP" wrote: Select both Bravo and Charlie (the text) and right-click and select Group and show Detail/Group. You will see the name Group1 which you can type over and enter Bravo(+Charlie) or whatever you like. Then you can drag the title KGS away (out of the pivot table). Bob Umlas Excel MVP "juanpablo" wrote: I have the following Pivot Table: Shipper KGS Alfa 1050 Bravo 2010 Charlie 960 Is it possible to only show the Pivot as this: Shipper KGS Alfa 1050 Bravo(+Charlie) 2970 Please JPG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
