Search code examples
tableau-apidimensionmeasure

Tableau converting dimension to measure

I have a technical question relating to Tableau. I have a Category field in the dimensions section which has three indicators: Disposable Income, GDP and Consumer Expenditure. I would like to convert 'Disposable Income' into a measure value on its own.

Is this possible to do?

snapshot

I cannot share the Tableau data source due to data restrictions.

Solution

  • Alternate solution to your problem I propose here, but it needs reshaping your data altogether. I have created a sample data for explanation like this

    input sample untidy data

    select three years column and click on pivot.. you will get a view like this after renaming the fields appropriately

    half tidy data

    From here you can proceed as described above.