Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sofia,
try
Sum(if(Period=$(vMaxMonth),Freq))/Sum(TOTAL <Dim> if(Period=$(vMaxMonth),Freq))
Regards,
Antonio
Hi Sofia,
try
Sum(if(Period=$(vMaxMonth),Freq))/Sum(TOTAL <Dim> if(Period=$(vMaxMonth),Freq))
Regards,
Antonio
It works! Thank you so much!!
Kind regards,
Sofia