0 Replies Latest reply on Oct 19, 2018 2:57 AM by dave.mann

    Multiple Table Calculations - differences between dimensions and years

    dave.mann

      I need to create 3 separate table calculations, which I have created in excel. I am struggling to do this in Tableau..

       

      I have one measure, which I

       

      * split as % of total

      * then calculate actual difference between years and dimensions

      * then % difference between years and dimensions.

       

      I can easily do % of total, but I can't figure out the other table calcs.

                                                                          

      201520152016201620172017
      CategorySomething is < 80%Something is >= 80%Something is < 80%Something is >= 80%Something is < 80%Something is >= 80%
      Category 1 % of total68%32%64%36%62%38%
      actual difference on previous year3033781053799
      % difference on previous year-4%4%-2%2%