Relative value does'nt work in stacked bar chart

[#1]

My stacked bar chart doesnt work when Im trying make the values into percent. My expression looks like this

Sum(if(Period=$(vMaxMonth),Freq))/Sum(if(Period=$(vMaxMonth), TOTAL <Dimension> Freq))

It works perfectly when using only the first part (Sum(if(Period=$(vMaxMonth),Freq))).

Any ideas what Im doing wrong?

Kind regards,

Sofia

[antoniotiman · Accepted solution]

Hi Sofia,

try

Sum(if(Period=$(vMaxMonth),Freq))/Sum(TOTAL <Dim> if(Period=$(vMaxMonth),Freq))

Regards,

Antonio

[#3]

It works! Thank you so much!!

Kind regards,

Sofia