ExcelBanter - Pivot

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot (https://www.excelbanter.com/excel-discussion-misc-queries/166183-pivot.html)

juanpablo

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

Bob Umlas, Excel MVP

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

juanpablo

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

All times are GMT +1. The time now is 09:55 AM.