Stacked barchart relative

[Anonymous]

Hello,

I'm trying to make a stacked barchart where dimension 'year' can be compared divided over dimension 'teams'. Each year should count up to 100% so we can see what the relative size of the teams are compared to total' and how it develops over the years.

In my chart  the selected years count up to a total 100% as you can see in the picture. Thats not what I want. Can anyone help me?

[sunny_talwar]

Don't use Relative option on the expression tab... rather use an expression like this

Count(Measure)/Count(TOTAL <jaar> Measure)