7 Replies Latest reply on May 15, 2018 2:09 PM by Okechukwu Ossai

    How to display a table to display exactly like SQL results?

    lawrence leo

      Hi, i have a custom SQL that does a group by 3 columns and displays the rows ordered by the sum of the values.

       

      When I try to display it in a table in Tableau, it groups the subcategory into the main category and orders the sum of the values after. (as shown in my attached sample screenshot, tableau_current.PNG)

       

      Is there anyway i can display the results as shown in my other screenshot tableau_desired.PNG?

       

      Thanks,

      Lawrence