Hi All,
I have one KF 0Amount in my Infocube. Data is as below in this KF:
FiscalYP 0Amount 2001000 0 2001001 100 2001002 200 2001003 -100 2001004 500 .. ... 2001012 100 2002000 0 2002001 300 2002002 200 ...
I need to calculate one KF that will represent the 0Amount for current month - 0Amout for previous month as below
FiscalYP CALKF 2001001 100 ( 100-0) 2001002 100 ( 200-100) 2001003 -300 ( -100-200) 2001004 600 ( 500-(-100)) ... .. 2002000 0 2002001 300 ( 300-0) .. ..
Problem is users want to report on all the years and fiscal period dynamically. He can either select one year or 5 years or 10 years. Initially I thought i can achieve with the help of customer exits, but I am find hard to make the logic.
Please guide me.
Aman
Edited by: AmanSharma123 on Jun 10, 2011 9:08 AM
Edited by: AmanSharma123 on Jun 10, 2011 9:17 AM