CODEWITHSUNDEEP
pivottableau-apidimensioncalculation
Vedad
Vedad

Reputation: 223

How to Pivot Calculations that were converted to Dimensions in Tableau

I want to make a Pivot on a few Calculation that I turned into Dimensions (TheCalculations are an IF THEN ELSE Construction returning 1 or 0). Now when I go to the Datasource and select thouse Columns i don't get the Option Pivot by presing the Drop Down Arrow. How I need to convert thouse Columns so I can Pivot them?

Thx

Upvotes: 1

Views: 1343

Answers (1)

Pirate X
Pirate X

Reputation: 3103

You cannot PIVOT any calculated field. This feature/idea was suggested in 2015 when v9 came out but not luck so far.

In their Tableau Online Help, it says -

You can pivot the data in your Microsoft Excel, text file, Google Sheets, and .pdf data sources

If you are open to different tool other than Tableau Desktop, take a look at Tableau Maestro

If you are using database as a source, try pivoting there and then using it with Tableau

Upvotes: 1

Related Questions