2 Replies Latest reply: Jun 12, 2017 6:47 AM by Sofia Anveden RSS

    Relative value does'nt work in stacked bar chart

    Sofia Anveden

      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