7 Replies Latest reply on Oct 27, 2016 5:06 AM by Matthias Goossens

    Can not Pivot Data from Columns to Rows

    Béatrice LORIOT

      Hi everyone,

       

      I really like the pivoting feature as described here http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#qs_pivot.html

      but now that I have 16 columns  = 16 products to pivot accross every day of the year, Tableau is not offering the pivot option anymore.

       

      This is what I have

        

      Sales per dateProduct 1Product 2Product 3Product 16
      01/01/2016100500450400
      01/02/2016100500450400
      20/10/2016300400300400

       

      This is what I  need.

        

      DateProduct name Sales amount
      01/01/2016Product 1100
      01/01/2016Product 2500
      01/01/2016Product 3450
      02/01/2016Product 1100
      02/01/2016Product 2500
      02/01/2016Product 3450

      I would like to rank my product by sales amount accross the year and other dimensions,such as country, region, etc...

       

      Thanks a lot,

      Very kind regards