I have a scenario where I have to create %ages formulas using SQL data source in Tableau. This would create additional set of measures in Tableau e.g. %age of Cost and other calc. fields and in the second step, I have to PIVOT these measures that we've just created in Tableau. i.e %age of Cost
|Entity||Sales||Cost||%age of Cost|
Constraints that I'm encountering:
1) Data Interpreter doesn't work with SQL data. It only works with Excel. (Note: The data is big enough for Excel to handle)
2) PIVOT is a manual process in Tableau. I reckon that it won't automatically pivot (new % measures) data on refresh every time data is reloaded ? I think it's a bummer.
What alternative approach do we have ?
If you want to do pivoting automatically it wont be possible. You need to do this at DB level and then connect the data to Tableau