As in a straight table, I can use dimension limit tab to define the value range that I want to show in the expressions.
However, in a pivot table, the dimension limit tab just disappears. Can I know is there a similar solution to pivot table? (besides doing it in SQL)
Use calculated dimensions (and set analysis if needed):
=If(YourValueRangeCheck, YourDimension, null())
Retrieving data ...