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