How to show consolidated values on visual without removing the dublicates in data set

[pakkirkani]

Hello Guys,

Please help me to get a solution on below.

there are 4 different POs combined under the same booking & I want to show them in the visual based on booking as a single value without removing the dublicates in the data since they are different POs.

PO	Category	Origin Country	Carrier	Booking reference	Arrival
45598155979	XXX	Spain	XXXX	24276953712	XXX
45598525981	XXX	Spain	XXXX	24276953712	XXX
45598559277	XXX	Spain	XXXX	24276953712	XXX
45598559182	XXX	Spain	XXXX	24276953712	XXX

Now showing as below -

[pakkirkani]

The outcome should come as 1 in the visual instead of 4 .

[lbendlin]

You would create a matrix visual that has both the booking reference and PO numbers.

In collapsed view you get the total number

In expanded view you get the PO details.

[pakkirkani]

I want to show in the clustered bar chart - is that possible 

[lbendlin]

No idea how that would look like. Why 1 and not 4  ?

[lbendlin]

what would be the expected outcome?