Does Custom SQL of Tableau 9 support the "PIVOT" and "UNPIVOT" functions?
I am currently converting Spotfire reports to Tableau and I wanted to know if Tableau can do this.
If not, what is the workaround?
Any help will be much appreciated.
I have another question.
Suppose I create a text table with only dimensions in Rows (the data has no measures), will I still be able to export the visualization into an excel on Tabelau Server? I use Tableau 9.