Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this
Aggr(If($(vTotals) >= $(vTotalLimit), [Branch]), Branch)
May be try this
Aggr(If($(vTotals) >= $(vTotalLimit), [Branch]), Branch)