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:



      After pivoting:



      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,