Time Range and Line item Period Allocation

LauranceJ

HI All,

 

I have a question since my mind has gone blank, I hope someone can help.

 

In my current model, i have imported data for a series of journeys which start on a weekly basis for each transport number, within the journey there are a series of stops for loading and then discharging stock. 

 

Pages: Time Range

Rows: Journey & Location number.

Column: line item - Location Name, Location load period, location discharge period 

 

For example for Transport Number 1:

Journey A:

Begin -  Week 1 at Location London

Location Paris on Week 5 to pick up stock Location Rome on Week 6 to drop off stock.

 

What i would like is for the assignment of the line item for "Location load  period" to align with the pages selector, however it is currently focusing on when the journey began.

 

i.e Currently if i chose week 1 in pages selector, it would show:

- London >> Paris -  Location load period Week 1, Location discharge period week 5

- Paris >> Rome  - Location load period Week 5, Location discharge period week 6

 

What I would like it to show is if i chose:

- Week 1 in the pages selector then : London >> Paris -  Location load period Week 1, Location discharge period week 5

- Week 5 in the pages selector then : Paris >> Rome  -  Location load period Week 5, Location discharge period week 6

 

I can not seem to find out how to change it so the pages selector changes from journey start period to Location load period

 

I hope the above makes sense and appreciative of any assistance.

 

Laurance Jones

LauranceJ

Hi Julien,

 

I thankyou for your time to respond to me, I will try this hoping this week and come back to you.

 

Thanks again for your assistance on this matter.

 

Laurance Jones