Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys
How can i choose two option in dimension expression
For example: I have a column that there are 3 options-> 'A', 'B', 'C'. I just want to display 2 options, 'A' and 'B'.
I text expression like this {<Column={'A','B'}>} , but it shows error
Include the equal sign at the beginning, with an aggregation function and a measure like below.
= Sum({<Column={'A','B'}>} Sales)
Include the equal sign at the beginning, with an aggregation function and a measure like below.
= Sum({<Column={'A','B'}>} Sales)
Need to do this
You need to specify the operation, than the field and the valor and then the field you wanna sum in this case
=Sum({<""={"A","B"}>}"Name of field what you wanna Sum")
@Diby Please use the below expression in your Dimension:
=Aggr(Only({<Value={'A','B'}>}Value),Value)
If this resolves your issue, please like and accept it as a solution.