4 Replies Latest reply on May 2, 2018 5:05 AM by Alexander Philipeit

    Pivoting of data in tableau by using SQL

    suhit mange

      Hi,

      I am creating a dashboard in tableau and its data is coming from SQL. Now i have a scenario where i want to display data in certain way for which Pivoting is needed. But tableau doesn't support pivoting of the data coming from SQL.

      Here is the format of data which i have,

      1.PNG

      And i want this data to be in the following format,

      2.PNG

      Now this kind of change i want to do it in my datasource section inside tableau and in my sheet. Since i cannot create pivot, how will i be able to achieve this thing ?

      I hope you understand my problem here. Please help me out with this.