2 Replies Latest reply on Nov 11, 2015 10:31 AM by Matthew Kuchers

    Can't Pivot Data using SQL server as data source...

    Matthew Kuchers

      I'm not entirely sure if this topic has been covered elsewhere but I can't find it anywhere via google. I'm trying to do the equivalent of pivot tables in SQL but do it in Tableau in the 'Data Source' view. The below article from the Tableau site shows a somewhat simplified version of what I'm trying to do. The thing is, it seems that this isn't possible with SQL server as my data source. Is this so? Is pivoting data only available using excel (or an equivalent data source), not SQL server? Whenever I go to select my data fields to pivot I only get the option to 'hide' the data.

       

      Pivot Data (from Columns to Rows)