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