How to display few matching entries from table.

[ashokqos]

Hi,

I have created a table something like this.
Name, Place , Business, Value
Bob, NY, Retail, 1000
Alice, Boston, Transport, 2000
Amit, Delhi, E-commerce, 500
Bob, NY, Entertainment, 1500
Usha, Mumbai, Films, 800
Alice, NY, Films, 5000
Alice, Boston, FastFood, 900

I want to display only those results where a person having 2 different businesses in same city.
Bob, NY, Retail, 1000
Bob, NY, Entertainment, 1500
Alice, Boston, Transport, 2000
Alice, Boston, FastFood, 900

Thanks for your help.

Regards
Ashok

[somesoni2 · Accepted solution]

Try something like this

your current search giving first table | eventstats count by Name,Place | where count=2 | fields - count

[ashokqos]

Wow!! Thanks a lot. I was trying to achieve the same result using subsearches.