Hello,
I have a table that contains the fields: year (YTD), current value, and previous value.
For the “previous value” column, I need it to always return the value from the prior year. However, when I apply filters, the results change based on the selected year, and the column that should display the previous fiscal values ends up returning zero.
I need the previous fiscal value to remain consistent and not be affected by the filters applied to the current year.
Since this is a duplicate post, archiving so that there’s no confusion in responses. Refer to the following thread for further communication around this topic: