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
|