Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the dimension i have to consider a Filed called IDNumber...
Iam writing the below expression
If(Status'Active'IDNumber)
Where ever the status is Active i want to display only those IDNUmber's
Is the above expression in the Dimension is correct
You can also do this
If(Status = 'Active', IDNumber)
and then make sure to check 'Suppress When Value Is Null' on the dimension tab of the chart properties
May be these?
If(Match(Status,'Active'),IDNumber)
OR
If(Status Like 'Active', IDNumber)
You can also do this
If(Status = 'Active', IDNumber)
and then make sure to check 'Suppress When Value Is Null' on the dimension tab of the chart properties
I think you may also try using the condition in your expression instead of Dimension as another approach.
=sum({< Status={'Active'} >}OrderID)