Dimension expression

[Diby]

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

[BrunPierre · Accepted solution]

Include the equal sign at the beginning, with an aggregation function and a measure like below.

= Sum({<Column={'A','B'}>} Sales)

[rui24]

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")

[sidhiq91]

@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.