0 Replies Latest reply on Jul 23, 2018 2:43 AM by thirupalu ch

    how to add custom totals after total button in text table in tableau

    thirupalu ch

      Hi tableau team,

      I have two tables one is normal and another one is target.

       

      I want show target values after total of report as shown in below

       

      first report

       

      region        sales           cm               per%      sales total     cm total    per%total

          1              1000        2000             50%           1000            2000           50%

         2             1000        2000             50%           1000            2000           50%

         3             1000        2000             50%           1000            2000           50%

      Total           3000       6000             50%            3000            6000            50%

       

      second report

      difff                                                                     500                  3500         30%

      tragt                                                              sales target vaue   cm target    per% target

      per                                                                     calculation           calculation   calucaulation

       

       

      As per the above can we achive the in tableau

       

       

      region        sales           cm               per%      sales total     cm total    per%total

          1              1000        2000             50%           1000            2000           50%

         2             1000        2000             50%           1000            2000           50%

         3             1000        2000             50%           1000            2000           50%

      Total           3000       6000             50%            3000            6000            50%

      difff                                                                     500                  3500         30%

      tragt                                                              sales target vaue   cm target    per% target

      per                                                                     calculation           calculation   calucaulation

       

       

      want to add custom totals after total button like the above?

       

      Please suggest me the same.

       

      Thanks,

      Thiru