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)
M1 - the last week (W4) is the only one we want to see in M1
Any suggestions would be appreaciated.