5 Replies Latest reply on Sep 22, 2017 10:26 AM by D Barnetson

    Pivot Data with Custom SQL

    Jan Paulsen

      Hi all,

       

      I really like Tableau's pivot option. Before pivoting:

       

      1.png

      After pivoting:

      2.png

       

      What I don't like is that this option is only available for flatfiles. Since I connect to a database I cannot use this option. 

       

      Is there any way to  do this with custom SQL? The sample data is attached.

       

      Kind regards,

       

      Jan