Relative values on stacked bar chart

[mike_spada]

Hi,

I'm struggling with this problem: I have a stacked bar chart with Year (Stack) and Class (Bar) as dimensions and an expression like this to count deliveries Count(distinct [Deliveries]). It works. Every stack is colored in a specific way (field called Color).

I'm trying to have the same bar chart but I need % values. I tried with this expression Count(Deliveries) / Count(TOTAL <Year> Deliveries) but it doesn't works: I have every stack on value "1". the wierd thing is that if I create a table with that expression... I have the correct % values!

The question is... why?? And... how can I solve it?

Thank you in advance.

Mike.

[marcus_sommer · Accepted solution]

It should be working - you may check various settings especially the ones how the dimensions are defined because yours shows Year and Class on the bottom ...

[mike_spada]

Thank you Marcus, I noticed that the dimension that I identified with "Class" was calculated as "=If(Year<Year(Today()), Class)", if I replace it simply with "Class" it works.

Have you any idea if I wish to keep that formula on dimension?

Thank you 

M.

[marcus_sommer]

You could try to include the condition within the expression, like:

Count({< Year = {"<$(=year(today()))"}>} Deliveries)