14 Replies Latest reply on May 17, 2018 1:52 PM by NAYANA MADHEKAR

    Calculations

    NAYANA MADHEKAR

      Hello there!

       

      I have a tricky one this time.  ( I think so)

       

      I have number of shops and their respective Sales.

       

      Shop1 = 100

      Shop 1=145

      .

      .

      .

      .

      Shop 10 = 456

      Shop 11= 1700

       

       

      But the Shop 11 is an online Store.. Therefore want to distribute that shop sales into the other stores according to their percentage of Total.

       

      Example: I have Percent of Total for all shops (1-10) except Shop 11.

       

      Now if Percent of Total for Shop1 is 3.03%

      Then the Sales of Shop 11 should be distributed as follows:  3.03% of 1700( Shop 11)  should be added under Shop1

                                                   4.39 of 1700 should be added under Shop2

                                                   5.33% of 1700 should be added under Shop3 & etc

       

      Is there a way we could accomplish this in Tableau? Please let me know if any questions.

       

      Desired output:

      Fruits          Sales

      Shop 1:      151.51

      Shop2:        219.63

      .

      .

      .

      Shop 10: 690.77

       

       

       

      Thank you.