
1. Re: Difference between two table calculations
Simon Runc Feb 13, 2019 3:31 AM (in response to Kevin Ross)1 of 1 people found this helpfulhi Kevin,
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
[Difference SR]
[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.

2. Re: Difference between two table calculations
Kevin Ross Feb 13, 2019 8:52 AM (in response to Simon Runc)Thank you so much Simon!