Dimension's field as input to variable

[ziabobaz]

Hello!

I have Funnel2 dimension, which is DUAL

i created variable MyVar=num(funnel2)

i created a table:

Dimension = Funnel2

Measure1 = $(MyVar)

Measure2 = num(STATUS)

The problem is that the Measure2 is null until i choose one of the dimensions. Is there way to force variable to compute a value even w/o selections in dimension field?

thank you!

[Anil_Babu_Samineni]

Can you try this as measure? num(funnel2) and show the image?

[ziabobaz · Accepted solution]

Sorry, funnel 2 = status in my case, so it returns the same.

However, I found the answer myself.

In the variable i wrote 'num(funnel2)' without 'equals' sign and it worked!