Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Sum({<Customer = p({<Year = {$(=Max(Year))}>})*p({<Year = {$(=Max(Year)-1)}>})>}Sales)
May be this
Sum({<Customer = p({<Year = {$(=Max(Year))}>})*p({<Year = {$(=Max(Year)-1)}>})>}Sales)
your gr8 stalwar1