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

    Cross database joins

    Sila Chea

      Hello,

       

      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

       

      2017-07-19_12-31-22.jpg

       

      Any ideas how to rectify this?

       

      Thank you!