Limiting Dimension Field Values based on variable values

[SanthoshEmmadi]

Hi All,

Is there a way to display the dimension values based on the variable value.

For example if I have the following table with Branch as a Dimension and Totals as an expression value which being derived from an expression using a variable vTotals:

Branch	Totals
New York	90
California	41
Texas	110
Cape Town	107
Durban	131

I have created another variable by name vTotalLimit which will be in an Input Box.

Now my target is to display the dimensions where the vTotals value is  >= vTotalLimit.

I tried to apply the following under Add Calculated Dimension but it displays all the dimensions.

=if($(vTotals )>=$(vTotalLimit),[Branch])

Can any one please suggest me a solution for it.

Thanks.

[sunny_talwar · Accepted solution]

May be try this

Aggr(If($(vTotals) >= $(vTotalLimit), [Branch]), Branch)

[SanthoshEmmadi]

Thank you very much. It worked !