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

    Creating Variances using parameters for multiple measure values

    daniel.leekim

      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.

       

      https://community.tableau.com/message/739415?et=watches.email.thread#739415

       

      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!