Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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)
Thanks.
Use calculated dimensions (and set analysis if needed):
=If(YourValueRangeCheck, YourDimension, null())