Set Analysis OR

[avastani]

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.

[avastani]

I am thinking I will probably not be able to solve this problem unless I introduce a neutral third date Date3 which does the summary of this metric in script and supports it as high dimensional levels than OrderLine and Orders