5 Replies Latest reply on Apr 16, 2012 6:45 AM by cedia.jabbie

    How to combine measures so they'll be one dimension?

      Im trying to combine my measure values into one dimension. How the data is shaped is shown below. What I'm missing is the material column that would let Tableau know if its wood, steel or wool. I cant reshape the data because the excel file is linked to underlying data. Also the file has over 4,000 rows so if I reshaped it my row/data sizes will grow exponentially larger than I would like.

       

      excelpng.png

       

      How do I aggregate wood, steel, and wool into one dimension called Material?

       

      Thanks, any help would be greatly appreciated.