5 Replies Latest reply on Sep 20, 2016 1:28 AM by lei.chen.0

    How to Perform a Measure Drill down like Pivot

    Haocheng Li

      Hello Tableau Experts,

       

      Greetings of the day.

      I’m about to perform below table in tableau, but didn’t get
      an efficient way.

      Could you experts please help me with this ?

       

      By the way, after create this table, I’m about to perform a
      metric sorting: Firstly sorted by [Region
      Total
      ] and secondary sorted by [State Total].

      Please let me know in case of any clarification.

       

      Region

      Region Total

      State

      State Total

      Central

      1. 501239.8908

      Illinois

      1. 80166.101

      Indiana

      1. 53555.36

      Iowa

      1. 4579.76

      Kansas

      1. 2914.31

      Michigan

      1. 76269.614

      Minnesota

      1. 29863.15

      Missouri

      1. 22205.15

      Nebraska

      1. 7464.93

      North Dakota

      1. 919.91

      Oklahoma

      1. 19683.39

      South Dakota

      1. 1315.56

      Texas

      1. 170188.0458

      Wisconsin

      1. 32114.61

      East

      1. 678781.24

      Connecticut

      1. 13384.357

      Delaware

      1. 27451.069

      District of Columbia

      1. 2865.02

      Maine

      1. 1270.53

      Maryland

      1. 23705.523

      Massachusetts

      1. 28634.434

      New Hampshire

      1. 7292.524

      New Jersey

      1. 35764.312

      New York

      1. 310876.271

      Ohio

      1. 78258.136

      Pennsylvania

      1. 116511.914

      Rhode Island

      1. 22627.956

      Vermont

      1. 8929.37

      West Virginia

      1. 1209.824

      South

      1. 391721.905

      Alabama

      1. 19510.64

      Arkansas

      1. 11678.13

      Florida

      1. 89473.708

      Georgia

      1. 49095.84

      Kentucky

      1. 36591.75

      Louisiana

      1. 9217.03

      Mississippi

      1. 10771.34

      North Carolina

      1. 55603.164

      South Carolina

      1. 8481.71

      Tennessee

      1. 30661.873

      Virginia

      1. 70636.72

      West

      1. 725457.8245

      Arizona

      1. 35282.001

      California

      1. 457687.6315

      Colorado

      1. 32108.118

      Idaho

      1. 4382.486

      Montana

      1. 5589.352

      Nevada

      1. 16729.102

      New Mexico

      1. 4783.522

      Oregon

      1. 17431.15

      Utah

      1. 11220.056

      Washington

      1. 138641.27

      Wyoming

      1. 1603.136

       

       

      Thanks & regards,

      Chris