Tableau converting dimension to measure

0
votes

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.

2
tableau-apidimensionmeasure
where have you stored your original data? Excel or text file or some other source? – AnilGoyal

2 Answers

2
votes

It is very easy. Add a calculated field named Disposable Income as-

IF [category] = 'Disposable Income' THEN [Measure_Val] END

Needless to say [Measure_val] is your measure field name here.

1
votes

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.