cancel
Showing results for 
Search instead for 
Did you mean: 

need help on report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

<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>

Former Member
0 Kudos

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

former_member184494
Active Contributor
0 Kudos

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