I was provided with two excel data file and i'm having issues with the joins. I've created a sample workbook (see attachement).
I'm trying to create a Dashboard with two sheets where i see my Sales details and also my Activites broken-down by Territory and Segmentation
Because my Sales data is broken-down by dates and my Activities isn't, when i do my join, the numbers are incorrect. It add Calls and Meeting to every line whereas those numbers are for the Fiscal Year
Any ideas how to rectify this?
You can fix it by using MAX or MIN for FY Calls or FY Meetings measures when you use it in your calculations.