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.
Hi @Lydiane,
This is fairly expected behavior as when you setup a filter, it will filters out by rows, therefore all of the information that applies outside of that window, will not be accessible.
There are a few different ways you can work around this, below is an article that dives deeper in to period over period computations and provides syntax to assist when building your calculated fields:
Additionally, you can consider looking further in to the PRE_FILTER option for your prior year data:
Hi @Lydiane,
Following up here as it has been a while since last communication took place on this thread, did you have any additional questions regarding your initial post or did the solution provided assist with your case?
Let us know if you have any questions within the next 3 business days or I’ll go ahead and mark the solution.
Thank you.
Hi @Lydiane ,
Since we have not heard back, I’ll go ahead and mark this as a solution. However, if you have any additional questions regarding your scenario, please feel free to create a new post in the community.
Thank you.
