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