Dynamic Dimension but in limit number

[wenkew186]

Hi all,

I have a pivot table. one of dimension have 5 values, and the dimension also is list box filter.

so now , I need limit this dimension show less 3 values, base on select in list box.

if no select then 3 values showing. if more than 3 values be selected then 3 showing.

how to do it?

thanks all！

[ValeriyaBartosh]

hello, use if clause with getselectedcount (FieldName [, IncludeExcluded]) function and rank()