Pivot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you very much.

Bob Umlas said:
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
Click to expand...
 
Back
Top