Drop key on to Rows Shelf, Variable to your Columns and value to your text mark , you will get the view you need.
No need to pivot the data
Unfortunately, the answer is no. The pivot function only works with Excel or Text files.
But have you ever tried to write a custom SQL statement?
You don't change the data on the SQL Server but build your own view for Tableau.
Thank you for the reply. I have tried your way and got the result as well but, i want to compare 'a' & 'b' where suppose 'a' is numeric datatype & 'b' is string datatype.
And for doing that i want to make the above thing exactly in my data source section in tableau. How will i be able to achieve that?
Also what kind of visualizations will be appropriate for this thing ?