5 Replies Latest reply on Jul 25, 2016 12:51 PM by Andrew Watson

# Converting Measure to Dimension

Hi All,

I am trying to pull a calculated field measure into a dimension but have been unsuccessful thus far.

I created two calculated fields to categorize fruit on both qualitative and quantitative measures. Then, I created a third calculated field to have Tableau sort them so that if they achieved low on one and higher on the other, they would be grouped among the superior class. It is an aggregate calculated field (I am not sure why).

Please let me know if you can help me -- this is urgent!

Thank you very much!

-K

• ###### 1. Re: Converting Measure to Dimension

Hi Kristen,

• ###### 2. Re: Converting Measure to Dimension

Thank you for the prompt response!

This is the calculated field:

IF ="Regular Quant" AND ="Regular Qual"

THEN "Regular Fruit"

ELSEIF ="Regular Quant" AND ="Premier Qual"

THEN "Premier Fruit"

ELSEIF ="Regular Quant" AND =”Gold Qual"

THEN "Gold Fruit"

END

• ###### 3. Re: Converting Measure to Dimension

The calculation seems correct to me. Maybe you can try to create a combined field instead.

Control click the two calculations and then right click and choose "Create-Combined Field". Hope it works

• ###### 4. Re: Converting Measure to Dimension

It is not allowing me to create a combined field when doing that – any other suggestions?

• ###### 5. Re: Converting Measure to Dimension

Does your formula work? If what field = "regular quant" and what field = "regular qual"? Something doesn't look quite right, generally you would need to specify the fields on which you want the calculation to apply.

IF [Field1] ="Regular Quant" AND [Field2] ="Regular Qual"

THEN "Regular Fruit"

...

END

Also what happens when [Field1] doesn't equal regular quant? What do you want to happen?