Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have a table in my sheet in which I have amount, description and year so I want to have a column for the amount of the previous year for all the materials so that when we select any particular year the amount of the year selected and the amount of the previous year should come, how can it be done, I have tried set expressions but the desired output is not coming.
You can acomplish that with a simple set analysis in your expression. Something like that
Sum({$<Year={"$(=Max(Year)-1"}>} Amount)