Amalgamate the bars of a pivot table

[smiler44]

I have some columns in a pivot table, say ABC ABC1, ABC2. I would like to amalgamate all the info into the column ABC.

Not sure how to do this

smiler44

 

[Brianwarnock]

This may sound stupid as I never worked with pivot tables, but from your info don't you just change the chart type from cluster column to 100% stacked.

Brian

 

[lemo]

select all three, right click and choose 'group'.

although, what if you just take that variable out of the column labels?

l

 

[noboffinme]

You could move all the fields (columns) to the 'Page' area of the Pivot & all data displayed would then be for all 3 fields.