Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
This
=Sum({$<Jahr= {"$(=Max(Jahr)-1)"}>} Umsatz)
thanks it works