Hello,
I have a cube with a key-figure: MilesCount (for example in a car this are all the miles the car has ever driven) and a year: 0CALYEAR
for example:
YEAR MILESCOUNT
2000 0
2001 1000
2002 2500
2003 3000
Now I want to calculate the difference between every year and the following year.
The Result should be the Miles driven in every year:
YEAR MILESCOUNT MPERYEAR
2000 0 1000 (1000-0)
2001 1000 1500 (2500-1000)
2002 2500 500 (3000-500)
2003 3000 -
Is this possible in BEx Query Designer ?
Thanks Armin