Hi Guys,
How do i get my fact table to be T_ReportTotalTasks and the other Location table to join it. Do i need to left Join the Location table to it or Create a key somehow?
The current way it is set the Task Rates are all Multiplied and incorrect.
![jamiemcc_0-1627638959444.png jamiemcc_0-1627638959444.png](/t5/image/serverpage/image-id/59481i0A50F248C236D09A/image-dimensions/551x508?v=v2)
Any solutions greatly appreciated.
Regards,
Jamie