Select Value Range to Show in Pivot Chart Expression

[#1]

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.

[whiteline]

Use calculated dimensions (and set analysis if needed):

=If(YourValueRangeCheck, YourDimension, null())