Show only records in pivot with data of previous year but not of current year

[Raymzzz]

Dear all,

I have a pivot with the sum of salesfee(=sum(SalesFee) per EmployerName and Year.

I would like to show only the records for each EmployerName that have data of previous year but not the current year.

Could anyone help me with this one?

Thanks in advance.

Stijn

[Kushal_Chawda · Accepted solution]

@Raymzzz  try below expression

=sum({<EmployerName={"=sum({<Year ={'$(=max(Year))'}>}SalesFee)=0 and sum({<Year ={'$(=max(Year)-1)'}>}SalesFee)>0"}>}SalesFee)

[Raymzzz]

Hi, thanks.  This is what I wanted.  Thanks a lot !