Skip to Content
0
Former Member
Mar 25, 2008 at 05:15 PM

Quantity four day before

12 Views

Hi guru

I need your help.

My cube contain: document date, material and order quantity.

I would like the order quantity by material at the 4 days before the document day

Exemple :

Doc date Material Order qty

25/03/2008 0033000001 100

22/03/2008 0033000001 20

21/03/2008 0033000001 50

25/03/2008 0033000003 100

22/03/2008 0033000003 60

21/03/2008 0033000003 40

If I execute report the 25/03/2008 I would like to see :

Material Order Qty(j-4)

0033000001 70

0033000003 100

And not

Material Order Qty

0033000001 170

0033000003 200

We do not have a user variable

Could you help me please

Best regards

Eric