How to limit the dropdown?

[deepti_singh]

Hi,

I have a straight table in which I have applied some limitations in 3 of the 10 columns. But when I insert the dropdown option for the three columns, the data in the drop down is not limited. Any idea how can I limit that as well, without limiting in the backend?

Thanks.

Regards,

Deepti

[ramoncova06]

would need to see you file, but you can try with

by apply an aggr to your expression

=Aggr(If(Sum(Sales)>=Max(TOTAL Aggr(Sum(Sales), Customer), 4), Customer), Customer)

Customers Having Top 4 Values

[deepti_singh]

Ramon,

I answered my own question. I made the mistake of limiting an expression and not the individual columns.
Thanks anyways!