9 Replies Latest reply on Apr 22, 2013 9:23 AM by Arthur Robbins

    Filtering when working with a vertical data structure

    Arthur Robbins

      Hello all,

       

      I am working with a dataset that has a vertical structure to the data. My goal is display this data in a more traditional horizontal format for reporting and then create the ability to filter on a particular attribute, say Year.  I have been able to create the horizontal layout easy enough but I am having difficulty getting the filtering to work as I would like. I am new to Tableau and was hoping some of you more experienced developers may have come across this before. My goal is create a filter for Year that would result in the whole row being displayed when the user made a selection, say 2012.

       

      Thanks for your help.

       

      Untitled picture.png

       

      Sample data

       

      Customer NumberAttributeValue
      1001ColorBlack
      1001MakeToyota
      1001ModelCamry
      1001Year2012
      1002ColorBlue
      1002MakeHonda
      1002ModelCivic
      1002Year2013