Copy a number in a chart to another column and row

[#1]

I am trying to build an MRP view in Qlikview and I just about have everything working with one exception, getting the Planned Order Release to show up in the right place.

I am calculating that for a given month I need to place an order or I will fall short of needs.  That particular item has a 120 day lead time, so the Planned Order Release needs to be 4 months prior to the Planned Order Receipt field.

Does anyone have any idea how to do this?  I am attaching what I am working on.

The filed that I am struggling with is Planned Order Releases, which should be the same number as the Planned Order Receipts field, just 120 days earlier.

Thanks,

Mike

[swuehl · Accepted solution]

Maybe like attached?

[#3]

Thank you very much, I believe I can make that work.