Subtotals and multiple dimensions in a barchart

[#1]

Hello ,

I have a requirement where I have to create a bar chart for comparing the zone wise sale of the product , I have data in the below format  :

Data:
Load * Inline [
Zone,ProdType,Sales1
North,Beer,200
North,SD,100
South,Beer,250
South,SD,80
];

I need to create a bar chart in such a way that the subtotals are visible and a concatenated zone and product type also comes as a bar for each dimension(North/South) ,

attaching a sample .

In the bar chart (required format),a 3rd bar having sum for beer and SD sale for each zone should be visible and should come as the first bar ,this bar's label can be North for NorthBeer and NorthSD .

[sunny_talwar]

For your current data, this seems to be working as well:

=Match(Pick(Dim, Zone&ProdType, Zone, ProdType, 'Total'), 'SD', 'Beer', 'Total')

[#3]

Works for me too , thanks once again