7 Replies Latest reply on Jan 26, 2017 5:29 AM by Shinichiro Murakami

    How to display 1 dimension data with 2 different parameter setting?

    PREUTTI PUAWADE

      Dear Tableau community,

       

      Need some solution from folks here. First I thought this assignment is a piece of cake. Turn out it's far away for a piece of cake after I've started to do this.

       

      Assignment is , I have such a raw data

       

      SNTEIDCODE
      A0001T010
      A0002T010
      A0003T06104
      A0004T09102
      A0005T030
      A0006T040
      A0007T04105
      A0008T03101
      A0009T090

      And I have to summarize them into this format

         

      CODEAll_TEIDT06_Only
      0937120
      10172
      1027
      10382
      10472
      1057
      1067
      1074
      10891
      10972
      Total1000129

       

      "T06_Only" is subset of "All_TEID" column.

       

      "T06_Only" must able to change to "T03_Only" or "T03_T09" depends on selected filter option.

       

      I've tried couple days but still cannot solve this so need advice or work around from the folks here.

       

      Please comment. Also attach sample of data here.

       

      Thank you in advance.

       

      Regard,

       

      Ohm.