4 Replies Latest reply on Jul 8, 2016 2:48 AM by Ashish Chaudhari

    Rank of Selected Customer , State, Region, Country

    SANDIP SHARMA

      Hi All,

       

      I have a data set, Out of that data set I want to calculate the rank of the of selected customer from the parameter and based on the selection who is topper in State, region & country. I have data for Country , State, Region, Customer Name and their Volume. I did the ranking on based on the volume in descending order than ranked them.

       

      Input Data

       

      Country

      Region

      State

      Customer Name

      Volume

      Rank (Calculated in Tableau)

      India

      West

      Mumbai

      JC-MU-01

      580

      1

      India

      North

      Delhi

      JC-DL-02

      400

      2

      India

      North

      Haryana

      JC-HR-04

      358

      3

      India

      North

      Delhi

      JC-DL-03

      350

      4

      India

      North

      Haryana

      JC-HR-03

      275

      5

      India

      North

      Delhi

      JC-DL-05

      230

      6

      India

      North

      Delhi

      JC-DL-01

      200

      7

      India

      North

      Delhi

      JC-DL-04

      175

      8

      India

      North

      Haryana

      JC-HR-02

      150

      9

      India

      North

      Haryana

      JC-HR-01

      100

      10

      India

      South

      Kerala

      JC-KR-01

      100

      11

      India

      North

      Haryana

      JC-HR-05

      47

      12

       

      From Above data, I choosed JC-HR-03,

       

      Required Output

      Selected Customer is (JC-HR-03)

      Volume

      Rank

      MY Customer

      275

      5

      State Customer

      358

      3

      Region Customer

      400

      2

      National Customer

      580

      1