How to move the the hiden box to the right and only display those un-hiden value ?

[paulyeo11]

Hi All

I like to know how to set , so that list box those items which is hide will move to right  ?

Paul

[paulyeo11]

Enclosed my QV Doc

[dharmarasu]

Hi paul,

try this....

in sort tab, write this expression

=only({<BRAND_P=p(BRAND_P)>}BRAND_P)

hope this helps.

Dharma

[ashfaq_haseeb · Accepted solution]

Hi

Go to sort tab deselect all, then try sort by frequency descending.

Regards

ASHFAQ

[paulyeo11]

Hi All

Both work , with out exxpression is better.