https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212254#M62118 <P>Try something like this</P> <PRE><CODE>your current search giving first table | eventstats count by Name,Place | where count=2 | fields - count </CODE></PRE> Wed, 02 Sep 2015 15:32:30 GMT somesoni2 2015-09-02T15:32:30Z https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212253#M62117 <P>Hi,</P> <P>I have created a table something like this.<BR /> Name, Place , Business, Value<BR /> Bob, NY, Retail, 1000<BR /> Alice, Boston, Transport, 2000<BR /> Amit, Delhi, E-commerce, 500<BR /> Bob, NY, Entertainment, 1500<BR /> Usha, Mumbai, Films, 800<BR /> Alice, NY, Films, 5000<BR /> Alice, Boston, FastFood, 900</P> <P>I want to display only those results where a person having 2 different businesses in same city.<BR /> Bob, NY, Retail, 1000<BR /> Bob, NY, Entertainment, 1500<BR /> Alice, Boston, Transport, 2000<BR /> Alice, Boston, FastFood, 900</P> <P>Thanks for your help.</P> <P>Regards<BR /> Ashok</P> Wed, 02 Sep 2015 14:35:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212253#M62117 ashokqos 2015-09-02T14:35:41Z https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212254#M62118 <P>Try something like this</P> <PRE><CODE>your current search giving first table | eventstats count by Name,Place | where count=2 | fields - count </CODE></PRE> Wed, 02 Sep 2015 15:32:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212254#M62118 somesoni2 2015-09-02T15:32:30Z https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212255#M62119 <P>Wow!! Thanks a lot. I was trying to achieve the same result using subsearches. </P> Wed, 02 Sep 2015 16:39:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-few-matching-entries-from-table/m-p/212255#M62119 ashokqos 2015-09-02T16:39:56Z