see the attached and below
1 create a formula for year -1
2 convert the result to a dimension
3 place the Year - 1 on your second sheet
4 go to your first sheet and open the Ano filter and select Apply to selected sheets
5 Select the second sheet
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hello Jim, Good Morning!
the comparative of the selected year and the previous year should interact with all the dimensions
and measures, but I see that in your example that only the year would be modified.
How could it be done so that the dimensions and measures interact with their respective year's value?