Prior Year Value: Page selector?
How can I view the actuals for a previous year, regardless of the current year? For example, if if July 2023 is selected, I want to see the full year 2022 actuals. Similarly, if July 2024 is selected, I want to see the full year actuals of 2023.
My current logic is only working for 2022 actuals.
Actuals = Amount [Lookup: 'ADMIN - Time Selection'.PY]]