Hello - I've created a pivot in Tableau but I am looking to calculate the variance between the two columns. With the variance calculated, I would like to have 3 separate columns that highlight the orig, des and then variance. Is this possible? Attached is what I have built out so far. The screen shot below is how I would like for the data to be presented in the end.
1 answer
Hello @Kaylee Luebke ,
See attached. You can use measure names and values instead of the pivot names. Use if statements to create a value for each pivot name. Then subtract the two.
@Kaylee Luebke
