3 Replies Latest reply: Oct 22, 2015 12:16 PM by AAA KKK RSS

    percentage in stack chart by cycle group

      Hi All,

       

      I have a problem that was in a part solved.

       

      I'm facing an issue with the Stack bar chart where I want to show the % for each stack that is relative to the entire bar

       

      I used this which works quite well with DIM1

      Sum(Sales) / Sum(TOTAL <DIM1> Sales)

       

      But I have a cycle group and when I use this :

      Sum(Sales) / Sum(TOTAL <GetCurrentField([GroupName])> Sales)  it doesn’t work.

       

      However the function GetCurrentField([GroupName])   is correct and return the current field used.

       

      Please help me.

       

      Thank you

       

      Am’