Skip to Content
0
Former Member
Dec 01, 2008 at 04:38 PM

Calculating with key figures of the following year

43 Views

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