Actual Value Month wise

[sona_sa]

Hi,

I have three years actual data. I want actual vs actual on the behalf of this expression - (Sum(Current Year Actual Value) - Sum(Previous Year Actual Value)) / Sum(Previous Year Actual Value).

Expression = (sum( {1<Year=,month>} CTS )-Above(Sum({1<Year=,month>} CTS)))/Above(Sum({1 <Year=,month>} CTS))*100

But I am getting only one year. i.e - 2013. In this Case - It should be 2014 and 2013.

For 2014 - Negative (-74.73) and For 2013 = +34.53. Now I have to show the graph on the drilldown of year wise ---> Month Wise.

But for the same graph Month value is coming same.

Please find the attached qvw for the same.

Thanks.

[marcus_sommer]

I'm not absolutely sure but I think there isn't a way to show this with one expression. The common approach to compare different time-periods in a single object is to use several expressions (instead time-periods as dimension) like these:

sum({< Year = {$(=max(Year))} > } Value) // current

sum({< Year = {$(=max(Year)-1)} > } Value) // previous

sum({< Year = {$(=max(Year))} > } Value) - sum({< Year = {$(=max(Year)-1)} > } Value) // deviation

- Marcus