Skip to Content
0
Former Member
Mar 03, 2010 at 10:15 PM

Macro Logic - Historical Inventory Calculation weekly - monthly

30 Views

Hi All,

I am trying to design a macro that allows us to view only the last weeks inventory value from a weekly data view in a monthly data view. I have tried a number of different settings such as Calculation Types and different Time Based Diaggregation settings in the planing area but without success.

It would look something like this:

W1...W2....W3....W4 - (these weeks are all in M1)

10....20......32......43

M1 - the last week (W4) is the only one we want to see in M1

43

Any suggestions would be appreaciated.

Paul