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 .

[#2]

Hello , please help or suggest any solution for this problem .

[sunny_talwar]

Is this what you are looking for?

[sunny_talwar]

Or are you looking for something like this?

[#5]

Hello Sunny ,

Thanks for the reply , I am looking for a third bar chart for each zone/prodtype combo, which contains the total for NorthBeer and NorthSD and same for SouthBeer and SouthSD .

Something like this :

Total

TotalBeer

TotalSD

North

NorthBeer

NorthSD

South

SouthBeer

SouthSD

Hope this helps .

[sunny_talwar]

Look at my other response below... does that help?

[#7]

Hi Sunny ,

This is very helpful but I need one more functionality where I get a similar kind of sub-division in total bar too(which must be the first bar) , is that possible ?

[sunny_talwar]

So move the total bar to the top?

Used a sorting expression:

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

[#9]

Hi Sunny ,

I might be confusing you but I want the total bar to be subdivided into 2 more bars for beer and SD :

Total

TotalBeer

TotalSD

[sunny_talwar]

This?