I have reporting where I want to report the difference between amount from one year to another year.
I want to pass Year and Year as prompts And then use them to filter my amount column
So amount where year = prompt1 and amount where year = prompt2
and calculated item amount - amount
is this possible?
Accomdate the 2 filters with the presentation variables and then pass the same presentation variables to the column where you need to calculate the change between the 2 years...
mark if helpful/correct..