Dear Experts,
my requirment is to know the evolution(stock) from month to month.
for example(for more explanation)
need to calculate opening stock of current month from closing stock of previous month.
i.e.(current month opening stock = previous month closing stock)
and evolution stock result will be calculated as
Difference between the « closing stock of Feb » « the closing of Jan » =evol result
The idea is to build a query that can deliver the results immediately.
report shoulb execute like this....
Calander year/month | Closing stock | Opening stock | Evolution
JAN 2000----
-
| 100 | NOVALUE(BLANK) |NOVALUE(BLANK)
FEB 2000----
| 150----
| 100----
-
| 50
MAR 2000----
| 170----
| 150----
-
| 20
For sure, the challenge is to see the « Closing period of January », reported as OPENING in the row of February.
Could you analyze this request, as Bex query
@The user should have the possibility to choose the periods he wants (variable interval mandatory).
Trying with cell definition and vertual key figure.please advice furher.
alternative are welcome.
Thanks in advance.
Edited by: S MB on Mar 18, 2008 3:13 PM
Edited by: S MB on Mar 18, 2008 3:19 PM
Edited by: S MB on Mar 18, 2008 3:20 PM
Edited by: S MB on Mar 18, 2008 3:21 PM
Edited by: S MB on Mar 18, 2008 3:23 PM