Here is my requirement......
I have actuals and Open orders as key figures in my query.....lets say if user runs the query in 2nd week of 10th period then it has to display
w1 w2 w3 w4
Open orders Actuals+ <=open orders for W2 Open Orders Open Orders
In other words when ever User runs the report then for that week it should add actuals + <=Open orders for the week User runs the report and for remaining weeks it should be open orders.
Can any one explain me how to achieve this in the Query?
Will be awarder good points...
Thanks in advance