Make Pivot Data available for standard database connections.
If it is available for custom SQL, then the next step is for all connections. We were told that custom SQL does not perform as well as dragging table pills into the connection canvas.
"You can pivot the data in your Microsoft Excel, text file, and Google Sheets data sources from crosstab format into columnar format to more easily perform analysis.
Or, if you are not working with the types of data listed, you can use custom SQL as an alternative way to pivot your data in Tableau. "
Read more at https://onlinehelp.tableau.com/current/pro/desktop/en-us/pivot.html#9owHroIGL84IBRpj.99