Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
So I have a problem that I'm not sure of how to solve with standard set analysis. The gist of the question is, which Customers have sales in 2014, but not 2015.
My feeling is that I need some kind of nested set analysis that would essentially say or something of the sort.
{<{
CustId -= {
{<2015={Year(OrderDate)}> Distinct CustId}
},
2014={Year(OrderDate)}
}>} Distinct CustId
I know I've horribly worded this question, but let me know if I need to clarify something.
Try {<Year={2014},CustId=E({<Year={2015}>}CustId)>}