We can change the grid to show people and then apply the aggregation from the toolbar from Bookings->People and order the bookings by Booking Date.
Example table structure:
image02-2.png
The next step is the first new cyprus mobile phone numbers extension – we can now also add the two fields we need from the insurances table to the grid and a default aggregation will be applied to both of these new columns.
If we select both of the Bookings columns and right-click on the column headers for the bookings fields to edit the aggregation we can change the function to ‘Last’.
Example table structure:
image01-2.png
However this time we need to also specify which Insurance field to order those transactions by (the Policy Date) as well as choose the Last.
Example table structure:
image03-1.png
Running the grid (and I’ve sorted the result) will give a screenshot as below with the information that we require.