Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Customers with sales in 2014, but not 2015

   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.

1 Reply
Gysbert_Wassenaar

Try {<Year={2014},CustId=E({<Year={2015}>}CustId)>}


talk is cheap, supply exceeds demand