Limiting Dimension Field Values based on variable values

SanthoshEmmadi — Wed, 02 Jan 2019 14:58:53 GMT

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.

Re: Limiting Dimension Field Values based on variable values

sunny_talwar — Wed, 02 Jan 2019 15:17:42 GMT

May be try this

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

Re: Limiting Dimension Field Values based on variable values

SanthoshEmmadi — Thu, 03 Jan 2019 08:35:45 GMT

Thank you very much. It worked !

topic Re: Limiting Dimension Field Values based on variable values in Water Cooler

Limiting Dimension Field Values based on variable values

Re: Limiting Dimension Field Values based on variable values

Re: Limiting Dimension Field Values based on variable values