6 Replies Latest reply on Jun 10, 2018 10:50 PM by Ravikumar Gangasani

    displaying columns dynamically

    kumar golla

      Greetings All,

      Table-1 has consists the pre- defined fields to be displayed for AccountId.Table -2 maintain the values to be displayed.

      We have a requirement where we need to display different columns dynamically in a Tableau report based on the ’account ID’ selected in the prompt. We tried multiple options and were able to only hide the data but not the column header. Could you please suggest if there are any solutions in Tableau to achieve the same? Please find below data.

      Table-1

      AccountID

      AccName

      RName

      Fields

      S fields

      St fields

      1

      abcd

      Cap111

      B2,B3,B4

      B2,B3,B4

      B2,B3,B4

      2

      efgh

      Cap111

      B1,B4,B3

      B1,B4,B3

      B1,B4,B3

      3

      jklm

      Cap111

      B1,B4,B2

      B1,B4,B2

      B1,B4,B2

      4

      ghij

      Cap111

      B1,B2,B3

      B1,B2,B3

      B1,B2,B3

      5

      hfgdd

      Cap111

      B1,B2,B3,B4

      B1,B2,B3,B4

      B1,B2,B3,B4

      6

      sdffr

      Cap111

      B1,B2,B3,B4

      B1,B2,B3,B4

      B1,B2,B3,B4

      7

      jgggdf

      Cap111

       

       

       

      Table-2

      AccountID

      AccName

      RName

      B1

      B2

      B3

      B4

      1

      abcd

      Cap111

      169868

      GA611

      HEALTH 4

      0M003

      2

      efgh

      Cap111

      169869

      GA612

      HEALTH 9

      0M006

      3

      jklm

      Cap111

      169869

      GA828

      HEALTH 9

      6AABH

      4

      ghij

      Cap111

      GA6121

      GA829

      HEALTH 9

      6AABH

      5

      hfgdd

      Cap111

      GA8288

      GA830

      HEALTH 9

      67AAK

      6

      sdffr

      Cap111

      170814

      GA831

      HEALTH 9

      6AABL

      7

      jgggdf

      Cap111

      170814

      GA832

      HEALTH 9

      HEALTH 9

       

      For example if I select Account Id=1  then it should display like below , whatever values present in  FieldDispalyed of Table -1...vice versa...

      Account id

      Account name

      B2

      B3

      B4

      1

      abcd

      GA611

      HEALTH 4

      0M003

      Thanks in advance.

       

      Regards,

      kumar