Skip to Content
0
Former Member
Jun 14, 2011 at 04:23 AM

Full year calculation : KF

31 Views

Hi Gurus,

I have data like below in my Info cube:

Period Amount

01.2011             100
02.2011             200
03.2011               50
04.2011             100
05.2011              300
06.2011               0
07.2011               0
08.2011               0
09.2011              100
10.2011              100
11.2011                100
12.2011                100
01.2012                 0
02.2012              100
..
..
12.2012                40

I want output like below:

01.2011          1050  ( sum of amount for all the periods for year 2011)
03.2011            1050
04.2011            1050
05.2011              1050
06.2011              1050
07.2011              1050
08.2011             1050
09.2011             1050
10.2011             1050
11.2011              1050
12.2011               1050

01.2012             sum of amount for all the periods for year 2012
02.2012               sum of amount for all the periods for year 2012
...
..

How can I achieve this? Please guide me.

Thanks

Aman