How to calculate

[#1]

Hello,

I have a chart that has the dimension YYYY-MM and one of the columns is Avg.

In the last column would I like to show Avg the same month last yearbut I cannot

get it working. What have

I done wrong?

Here is the calcultaion I try.

kindly

Håkan

[sunny_talwar]

May be you need to use The As-Of Table

[ganeshsvm]

Try like this in Set for PeriodID,

PeriodID = {"$(=Max(PeriodID)-11)"}

[Anonymous]

sum( {<periodid={"$(=AddYears(Month(PeriodID),-1))"}>} $(vnettofors)/$(vnettoant) )

[#5]

I found a link to Above() in your suggestion and this solved it.

The Above Function