1 of 1 people found this helpful
If I understand what you are after correctly, this should do the trick...
First I made your "quick table calculation" a real calculated field, so I could reference it in another calculation (you can hold CTRL and drag it onto the Measures, left hand pane, and it will become a real calculated field)
Once I had this I created this calculation
[Total Billing YoY Var %]
LOOKUP([Total Billing YoY Var %],-1)
What we have here is a nested Table Calculation (the original one giving the % difference) and then this one with the LOOKUP function. When we get this we can get Tableau to run them over different levels.
So I set up this element like this
So on this part the LOOKUP works over year.
Hope that is what you were after and makes sense.
Thank you so much Simon!