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

    Divide two measures within a certain dates

    john Doe



      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

      July 2July 4


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