5 Replies Latest reply on Jun 27, 2018 4:24 PM by Don Wise

    % Change Calculation

    Vandana Samtani

      Hi guys,


      I have a list of title information and the user wants to calculate the % Change Calculation. Below i the view in excel that I am trying to replicate in tableau -

      The users can select any titles for calculating % change but any given time it's going to be 2 titles only.



      The change calculation for weekend  =  (Weekend of Title1/Weekend of Title 2) -1

      The change calculation for Gross Total = (Gross Total Of Title1/Gross Total Of Title 2) - 1




      Any suggestion on the calculations  as well as the layout will be helpful.