6 Replies Latest reply on Jan 29, 2019 12:45 AM by Donna Coles

    Blended data sets not resulting in desired solution

    Alex Martino

      Hello. I have two data sets that I'm blending by month. One has categories and expenses (on a daily basis) and the other has sales orders on a daily basis.

       

      I want to look at categories and divide by TOTAL sales. But the problem is that for categories that don't have expenses in every month, it reduces the # of sales for that category. The total number of sales is 84,399 which shows up for the sub heads that have entries in every month. I would like to do this at the monthly level as well but run into the same issue

       

       

      Screen Shot 2019-01-20 at 12.12.19 PM.png