0 Replies Latest reply: Oct 25, 2016 11:42 PM by William Choo RSS

    Use chart dimension as value in set expression

    William Choo

      Hi All,

       

      I am trying to create a Chart for Renewal Rate based on 3 dimensions: Revenue, Year, Expiry_Year but the calculation of Renewal Rate would only be based on Expiry_Year and Revenue

      I have a list box that allows me to select Expiry_Year from 2010 - 2017. If I select both 2015 and 2016, I would like to create a Chart as follows:

       

      YearRenewal Rate
      2015calc based on Expiry_Year = 2015
      2016calc based on Expiry_Year = 2016

       

      The expression I was using is sum( {<Expiry_Year=p(Year)>}Revenue) ,which isn't returning the expected results.

       

      How do I create a Set expression that uses the current Year i.e. current row in the chart, for the Expiry_Year = {} value?

       

      Thanks in advance.