Change in expression according to selected list box value

[anagharao]

Hi all,

I have a requirement to show the results of a survey. The questions asked in the survey have varied answers. Sometimes the answers are text and limited however sometimes they are numbers and are unlimited.

I would like to change the Dimension in the graph according to the question selected.

For example:

(see attached)

Question 1 - Select the fruit you like - Dimension : Answer

Question 2 - Enter a number you like - Dimension : CLASS(Answer,10)

Please help me out in changing this through a excel sheet and not IF condition (as the number of questions are a lot). Also the Class expression above is leading to an error.

Regards,

Anagha

[Anonymous]

Hi,

you can use a calculated dimension like this:

=if(istext(Answer), Answer, Class(Answer, 10))

Let me know!