4 Replies Latest reply on Jul 23, 2018 10:25 PM by Hari Ankem

    Divide two measures within a certain dates

    john Doe

      Hi,

       

      First time on here and hoping someone can help me out. I won't be able to share the workbook, but I will explain the best I could. I'm looking for cash to sales % by a date range.

       

      Data layout:

       

      • DateStoreTotal SalesTotal Cash
        July 1A10020
        July 1B20050
        July 2A12515
        July 2B12285
        July 3A10065
        July 3B15552
        July 4A300152
        July 4B15754

       

      I have a parameters with Start and End Date

      StartEnd
      July 2July 4

       

      Also, I have multiple values (drop down) filter.