Multi Dimensional Bar Chart

[MK_QSL]

Hello Experts !

I have below data.

Data:

Load * Inline

[

  Year, Country, Customer, Sales

  2014, India, A, 100

  2015, India, A, 120

  2016, India, A, 190

  2014, India, B, 140

  2015, India, B, 200

  2016, India, B, 290

  2014, India, C, 300

  2015, India, C, 200

  2016, India, C, 400

  2014, France, A, 450

  2015, France, A, 350

  2016, France, A, 600

  2014, France, B, 180

  2015, France, B, 360

  2016, France, B, 200

  2014, France, D, 450

  2015, France, D, 550

  2016, France, D, 650

  2014, UK, E, 400

  2015, UK, E, 500

  2016, UK, E, 600

  2014, UK, B, 350

  2015, UK, B, 250

  2016, UK, B, 700

  2014, UK, D, 600

  2015, UK, D, 500

  2016, UK, D, 650

];

I want to create a bar chart with

Country, Customer and Year as Dimensions

and

SUM({<Year = {'$(=Max(Year))'}>}Sales) as an expression.

This is the image which I got after implementing above dimensions and expression.

My question is ....

as we don't have Customer C and E for France, Customer D and E for India and Customer A and C for UK... how can we remove those customers' empty bar space from above chart?

Hope I am clear on my question and explanation !

Regards,

MK

[marcus_sommer]

I like the idea. Maybe such dummy-value could be simply set transparent - argb(0,0,0,0).

- Marcus

[MK_QSL]

Hi Ruben,

This is really a nice idea. At least the nearest answer. Don't know about performance with large data set.

Thanks for your answer.

[trdandamudi]

Is stacked bar is ok like below: