Pivot tables - 14 Days - Bike set up

To assist with rostering, and scheduling at Depot level, there is now a 14-day Bike set-up Pivot Table. This is a one-click function, which removes the need to first make Ad-Hoc selections.

• From the Main Menu | Depot | Diary

• Set the Date on the right hand side of the screen to be the starting point for the 14 days,
• then click the Pivot Table - 14 Days - Bike set up button

• This gives you a count of bikes in the selected 14 day period
• Add the Model, and Size fields to the vertical axis and the date field to the horizontal axis
• this can now be sorted into chronological order with the addition of the date at field