I'm a bit lost and I've probably missed a step somewhere.
I am trying to link my BookingsTable to my FlightTable.
I loaded both tables into the Data Model as connections, then New Blank Query to link the two tables. The BookingsTable is all unique references.
But when I build a pivot by Booking Ref (the key field) to display airline, it just brings through all airlines on the report.
Attached is my example.
Can anyone please help?
Thanks
Chris
I am trying to link my BookingsTable to my FlightTable.
I loaded both tables into the Data Model as connections, then New Blank Query to link the two tables. The BookingsTable is all unique references.
But when I build a pivot by Booking Ref (the key field) to display airline, it just brings through all airlines on the report.
Attached is my example.
Can anyone please help?
Thanks
Chris