1 Reply Latest reply on Jul 19, 2017 10:33 AM by Sherzodbek Ibragimov

    Cross database joins

    Sila Chea



      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?


      Thank you!