3 Replies Latest reply on Jul 23, 2018 2:27 AM by thirupalu ch

    Fact Vs Fact in a single table workaround in tableau

    thirupalu ch

      Hi I have rare sceanrio,

       

      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 in tableau

       

      Please suggst me .

       

      Thanks,

      Thiru

        • 1. Re: Fact Vs Fact in a single table workaround in tableau
          504842865qq.com.

          Hi,

               Thiru: Is your original data set wrong?

               it would be better if you can express what you're expecting clearly

               look forword your reply.

          thank you

          • 2. Re: Fact Vs Fact in a single table workaround in tableau
            thirupalu ch

            Hi ,

             

            sorry,

            it is dummy data , so it is 2 only int the top portion.

             

            what i want is in any normal text table in tableau we will get

             

            region      sales loss   per%    total of sales      total of loss    total of per%

             

             

            total               ---            ---             ---                ----                           ----

             

             

            in addition to that total i want to add some more custom totlas.

             

             

            IS that clear or some more explanation with diagrams also i am ready to explain.

             

             

            Thanks

            Thiru

            • 3. Re: Fact Vs Fact in a single table workaround in tableau
              thirupalu ch

              Hi,

              want to add some more information

              the below two reports as a single reprot.

              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%

              difff                                                                     500                  3500         30%

              tragt                                                              sales target vaue   cm target    per% target

              per                                                                     calculation           calculation   calucaulation

               

               

              As per the above can we achive in tableau

               

              Please suggst me

               

              Thanks and Regrads,

              Thiru