Thread: Pivot
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default 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