13 Replies Latest reply: Jan 12, 2017 3:46 AM by Louis Lam RSS

    How to set expression for field comparsion?

    Louis Lam

      Hi All,

       

      FromToDate
      1/18/201612/12/20163/3/2016
      2/14/20161/17/20171/1/2015
      3/14/20164/1/20162/6//2016
      4/19/20167/7/20177/7/2016

       

      I would like to count the number of record where date > from  and date < to in the pivot table with dimension month(date)&year(date)

      Many Thx!

       

      Best Regards,

      Louis