Requirement to populate a kyf on the fly
I have requirement where a key figure should be populated at runtime. My infocube has a customer as char and key figures january purchase, february balance, march purchase and so on. Now I need to create a variable entry for calmonth. If the user enters month as february (02) then the report should look like
Customer|| January|| February|| Total
001 ||100000 ||30000|| 130000
002 || 20000|| 15000|| 35000
and if the user selects month as March (03) then the report should look like
Customer|| January|| February|| March|| Total
001 || 100000|| 30000|| 20000|| 150000
002|| 20000|| 15000|| 15000|| 50000
The total key figure should populate depending on what month the user has selected but it should add the preceding columns.
So my question is how do I get it done? How can I get a kyf to calculate on the fly?? Please help.