4 Replies Latest reply: Jul 10, 2013 4:30 AM by stevenfosters RSS

    Calculate with Set Analysis

      Hi evereybody

       

      I have a calculated dimension like this: if(Account_Group = 'WHVIGREV','Gross Revenue', ..., Null())

      This dimension works perfectly!

       

      I created a bar chart with the calculated dimension and as an expression a Set Analysis like this: Sum( {$ <  Version={ACT}, Account_Group=  > } EUR*-1)

      It works too!

       

      But now I´d like to create a bar chart where I can calculate with Set Analysis like this: Sum( {$ <  Version={ACT}, Account_Group=  > } EUR*-1) / Sum( {$ <  Version={ACT}, Account_Group= {WHVIGREV}  > } EUR*-1)*100

      In this case WHVIGREV is Gross Revenue and I want to show the percentage of every position in the calculated dimension of WHVIGREV (Gross Revenue).

       

      Could anybody help me?

       

      Regards

      Steven