on 07-29-2007 6:59 PM
Hello gurus,
Some one help me to solve this report..
i need to display the average for the selected month and the plan amount for the next three months..
also there should not be any variable input.
when user selects a month from filter automatically it should show the data for the next three months (Plan amount).
Help me if some one is not getting the requirement based on ur information i can explain more..
thanks
Srini
<font face = verdana>
Hi<br>
Store value of month entered by user in some User Entry Variable.<br>
Design Restricted Key Figures for planned values and restrict these key figures to the User Entry Variable with Offset Values like +1, +2, +3 like this.<br>
<br>
Give it a try and you will understand what I am trying to advice. Feel free to come back if you are struck.<br><br>
Cheers<br>
Abhijit
</font>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Abhijit,
I can understand but user says he does not need any variable input.
0calmoth is placed in free characteristics and if the user restricts a month after executing the report it has to show the data for the selected or restricted month and also with the next three months plan amount.
thats the problem i need to solve.
Also we thought to fix the plan amount alone for the next three months from the current month but when we select the 2 nd or 3 rd month the data is not getting displayed for the restricted next three months from the current month..
Suggestions please to solve this...
Thanks
Srinivas,
If you have calmonth and restrict the same in free characteristics - you will not get the data for the other months in the report. Create all your KFs as restricted KFs and have current month data also as a restricted KF and have three more RKFs for the plan data and it will work properly.
And remove calmonth from the free chars..
Arun
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.