1 Reply Latest reply on Jul 2, 2016 7:16 AM by priyanka reddy

    How to group data based on different date fields?

    AnhVi Hoang

      I have a table and need to group two measures by month based on:

       

      1. Count of orders based on purchase date

      2. Sum of sales based on paid date (most of the time they are in the same month, but not always)

       

      Thank you very much,

       

      Tuan Hoang