Limit a straight table to not show certain rows

[#1]

I have a table where I'm trying to restrict rows and enabling conditions doesn't seem to do the trick for me.  I can simplyfy the data for the purpose of an example here.

status	sum(lead_count)
Accepted	1416
Review	37
Ineligible	193
Declined	186
Pending	1

If I have the data above, and I only want to show rows where the lead_count > 1, how would I do that?  I tried to enable a lead_count > 1 condition within the dimension and expression, but neither technique worked.   Any help would be appreciated.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

You can use a calculated dimension: if(aggr(sum(lead_count),status)>1,status)

or a set analysis expression: count({<status={'=count(lead_count)>1'}>} status)

or you can use Dimension limits and use the option Show only values that are Greater Than 1 exact amount

See attached example.

[#3]

Thanks!  That worked.