8 Replies Latest reply on Jun 14, 2016 12:24 AM by koushik.neelakantha

    Top Sales/Customer WRT City

    koushik.neelakantha

      Hello team,

       

      Please find the attached workbook( Please refer Top10 sheet).

       

      I Have city and customer Columns. Is it possible to calculate Top 10 Customers (Taking sales) for all cities or individual?

       

      Kindly help me out.

       

      Regards,

      Koushik.

        • 1. Re: Top Sales/Customer WRT City
          kumar.c

          Hi Koushik,

          You mean to say for particular city Top 10 Customers or less if there are less customers, like below?

          1 of 1 people found this helpful
          • 2. Re: Top Sales/Customer WRT City
            koushik.neelakantha

            Helo Kumar,

             

            Above logic is the perfect one. Can you please provide me the calculated logic for the above one.

             

            and my second scenario is, I need to display Overall Top 10 customers. Above logic is wrt city and customer wise, If there are 100 customers, I need to display Just  top 10 customers Taking city as well.

             

            For example: I have  5 customers in hyderabad, 10 in Bangalore, 10 in Pune & 5 in Mumbai. I need to display Overall Top10 customers out of 30 customers from 4 cities taking city col as well.

             

            regards,

            Koushik

            • 3. Re: Top Sales/Customer WRT City
              kumar.c

              Hi Koushik,

              For above logic,

              first I have taken the one more sales onto the rows beside the Product Name, by default it is measure (continuous).

               

              In below example, I have taken Region and Product Name, instead of that you can take City and Customer in your scenario.

              2. Then right click on the Sales that is there in the rows and change it to discrete from continuous.

              3. Then change this to Rank from tableau calculation

              Drag this sales between Region and Product Name in the rows.

              5. Here we want to see the rank for particular products based on the Region, so we need to compute using Product Name as below:

              so it will give the ranks for every individual Products as per image.

              Hope this helps.

              1 of 1 people found this helpful
              • 4. Re: Top Sales/Customer WRT City
                koushik.neelakantha

                Hello Kumar,

                 

                Thanks a lot for the Logic.

                Can you please send me the logic for below scenario in the same way.

                 

                and my second scenario is, I need to display Overall Top 10 product names.  If there are 100 customers or product names , I need to display Just  top 10 customers Taking region as well.

                 

                For example: I have  5 customers or product names in east, 10 in west, 10 in north & 5 in central. I need to display Overall Top10 product names out of 30 product names from 4 region taking region col as well.

                 

                regards,

                Koushik

                • 5. Re: Top Sales/Customer WRT City
                  kumar.c

                  Hi Koushik,

                  Are you looking like below image:

                  What is the logic here is it is taking the highest values and checking among all the cities and showing Top 10, means from every City one customer.

                  1 of 1 people found this helpful
                  • 6. Re: Top Sales/Customer WRT City
                    koushik.neelakantha

                    Hello Kumar,

                     

                    yes exactly the same logic I am looking for, Top10 logic is perfect can u share me the Bottom 10 logic(taking the Lowest values and checking among all the cities and showing Bottom 10, means from every City one customer.)

                     

                    Can u share me both the Logics?

                     

                    Regards,

                    Koushik

                    • 7. Re: Top Sales/Customer WRT City
                      kumar.c

                      Hi Koushik,

                      Are you looking anything like this for Bottom 10,

                      1 of 1 people found this helpful
                      • 8. Re: Top Sales/Customer WRT City
                        koushik.neelakantha

                        Hello Kumar,

                         

                        Yes i am looking for the same Logic, Can u please share me the logic for top10/bottom 10.

                         

                        and can we sort the same WRT High/Low sales?

                         

                        regards,

                        Koushik