Right now iam working on Profit and loss Report.
Client given one format to me.
In key figure section i need to design current month BUDGEST,And Cummulative BUDGEST.
How to design this format?
I need to use any structure?In dimensions which one select?
plz tell me step by step
Thanks for your intrest
Thnaks in advance
You might be having Key figure 0Amount. For getting the current month budget you will have to select this key figure and restrict this by using a time characteristic, Fiscal year/Period. use a variable that is a single value input and mandatory additionally you will have to restict for characteristice Valur type for reporting for either "20" (Plan) or "30" (Budget), check the correct one from the functional consultant.
Now for getting the cumulative budget, you will have to do the same restirctions as mentioned above, But for the variable Fiscal Year/ Period you will have to restrict it with a operand <= the variable that is a single value input. This will get you the cumulative budget. hear again if you only the budget for the current year, you willl have to restrict additionally for time characteristic Fiscal Year.
Hope the above is use ful.
Please assign reward points if the above answer was helpful to you.