Stacked Bar chart with 2 expressions and 2 dimensions

[abubakarsiddiq7]

i have two measures and 2 dimensions(Month and col) .Month is having all the months and colomn1 having yes ,no,# values(ignore #).Expressions are sum(current Year sales ) and sum(Previous Year sales).

i need  a bar chart with sum(current Year sales ) and sum(Previous Year sales) and on top of this bar need to plat colomn1 field values with different color.

Sample file attached .

[JordyWegman]

Hi,

This is not possible to make. What you can do is create two bar charts that show the same but then for last/current year. You can also use a container object for showing this in one object, but then you can switch. 

Another option would be to create one with the stacked bars and the other two measures in 'circles/blocks' etc. Then you can compare the last/current years but they have an overlay. Do you know what I mean?

Jordy

Climber