Dear all!

I am new to Crystal Reports as a collegue of mine left the company and I got to do the whole reporting with Crystal Reports 2013.

What the reports should show is the following:

Our sales wants to compare the costumer per month from two different years, to see:

• e.g. if costumers bought something in Mai 2016 and not in Mai 2017(lost costumers) or
  
• if costumers bought something in Mai 2017 and not in Mai 2016(new costumers)
  

I tried to achieve this with a crosstab, but i always get a mixture of both, lost and new costumers...

I've created a filter for the years and months, added the month to the groupheader and added the year to the columns of the crosstab afterwards.
The row consists of the costumer name and the employee that was in charge. As a group result i added the sum of the money.

I don't know if this is enough information for you... If you need anything, please ask :/

Thank you very much in advance for your help!