Year plus one

[jelindbe]

I need to display a measure for "2010" as "2011", "2011" as "2012"....etc.

I have tried this formula (with many variations):

Sum({<Year={$(={Year}+1)} >}my_measure)

but it returns with 0. I would greatly appreciate any assistance.

[OmarBenSalem · Accepted solution]

To adapt to ur case Jon Erik:

use a chart, as dimension: Year

as a measure:

sum({<Year>}aggr(below(sum({<Year>}YourMeasure)) , (Year,(NUMERIC, ASCENDING))))

[sunny_talwar]

But this expression is only if you have Year as dimension... in case you have more dimensions in the chart, you need to add them to your Aggr() function and make sure to have them before the Year dimension.

[OmarBenSalem]

Yes sure !

[jelindbe]

Thank you very much. It worked fine! Now I must study why it worked... 🙂