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?
