Show Last Years Sales on New Employee

[Emir_Peker]

Hello everyone,

I encountered a problem in our company's sales reports. In general, the sales representatives of our business partners we work with are changed every year and our reports contain comparisons with last year. When the sales representative for the previous year changes, the turnover of last year is 0 but it shows the turnover of the new year, or other way around. How can I show the turnover of last year in the new sales representative?

I thought of using IF condition but I didn't know how to do it. Therefore, I request your support. Hope, I made myself clear.

[Emir_Peker · Accepted solution]

I found the solution so thank you for your help.