In the Tablix property of the grid we add the filter in any rages.
1. All the operator are common and except < > . This < > for != Not equals to ranges.
2. We cant add multiple ranges of same filed in same expression values whereas we need to create n number of filters against the expression to add ranges accordingly.
3. Working on Row visibiliy expression is not recomended to achiew this ranges.
4. To have AND condition in the value needs to add between Value1 and Value2