Good afternoon,
Is there a way to exclude ‘old’ months from the available items in page selectors? Currently I have a P&L that uses a dynamic variable (‘latest month’) as a source for the YTD calculation in a calculated column. Users can change the value of this variable in their sessions.
Like so:
I have my month dimension in the page selector and set the default as the dynamic variable so that the P&L is automatically filtered on the latest month.
But the ‘problem’ now is that the visible page selector shows all the available months but I want to limit this to only the last year and current year only.
Is there a way to limit the page selector options to only the recent months while keeping the dynamic variable for the YTD calculation intact?
