Set Analysis

[vanderson009]

I have below data and i want to display customer name those having Sales for max year as well as previous year.

Year	Customer	Sales
2018	A	10
2018	B	20
2017	A	30
2016	C	40
20016	C	10

Regards,

Villyee

[sunny_talwar · Accepted solution]

May be this

Sum({<Customer = p({<Year = {$(=Max(Year))}>})*p({<Year = {$(=Max(Year)-1)}>})>}Sales)

[vanderson009]

your gr8 stalwar1‌