3 Replies Latest reply on Jun 11, 2018 1:02 PM by Jim Dehner

    Creating Variances using parameters for multiple measure values


      Good afternoon,


      I am finishing up my Tableau reports on crosstabs and the only thing left is making a dynamic variance tab that would allow users to pick any two years from a list of 3+ years. I have found the link below to help me get started and for the most part, I think parameters is the way for me to go.




      My problem right now is that I would like to have the years as my column and a lot of different measure values as my rows that may include things such as revenue, expense, etc. When using the formulas in the link, I can only select one measure. Is there a way I can create a way to compare variances year over year on a column where the rows are 20+ different measures?


      Thank you very much and any help is greatly appreciated!