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:
Year | Renewal Rate |
---|
2015 | calc based on Expiry_Year = 2015 |
2016 | calc 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.