1 Reply Latest reply: Jun 26, 2013 11:16 PM by Amirali Vastani RSS

    Set Analysis OR

    Amirali Vastani

      What would the set analysis expression in COUNT(OrderLineID) be for those values where Date1 OR Date2 have the same Month Year and Month Year is determined using Date2

       

      Sample Data

       

       

      Date1, Date2, OrderLineID, Amt, Qty

      3/4/2013, 4/1/2013, 1, 3409, 34

      4/5/2013, 4/6/2013, 2, 56, 1

      4/20/2013, 5/1/2013, 3, 49, 3

      2/1/2011, 3/31/2013, 4, 5959, 2

       

      the result in the above data set should be 3 when the X-axis uses Month(Date2) for time series

       

      any ideas? I think an OR in set analysis is needed.