Year before selected

[franziska_greis]

Hello I am looking for expression in set anaysis like this one:

=sum({$<Jahr={2017}>}Umsatz)

But the year should not be fixed - it should be the year before selected.

Thanks for help ;o)

[sunny_talwar]

This

=Sum({$<Jahr= {"$(=Max(Jahr)-1)"}>} Umsatz)

[franziska_greis]

thanks it works