For the first request, difference between all Values, I'm assuming you mean the either the difference from the first year to the latest or the difference from year to year. The attached is an example of the first. I've just used the Amount field and added a quick table calculation on it by right clicking and selecting Quick Table Calculation > Difference. I right clicked on it again to select Relative To > First. You can do this with the other metrics and select whether you want it to compare to the first year or just the prior.
I'm not aware of a way to restrict selection to just two years other than parameterizing your metrics to a selected year. The user could then select whether to compare to the prior year or another preceding year.
If this post 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.
payerreport (WM).twbx 19.3 KB