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