https://community.splunk.com/t5/Splunk-Search/How-to-add-two-rows-to-one/m-p/486360#M136063 <P>Try this!</P> <PRE><CODE>(your search) |stats sum(count) as count by Fruit </CODE></PRE> Thu, 26 Sep 2019 14:34:41 GMT HiroshiSatoh 2019-09-26T14:34:41Z https://community.splunk.com/t5/Splunk-Search/How-to-add-two-rows-to-one/m-p/486359#M136062 <P>I have 2 rows with same field name, how do I add the count of 2 rows and display the result in one row. <BR /> please find the example:</P> <P><STRONG>Fruit | A | count</STRONG></P> <P><STRONG>apple |3 | 3<BR /> apple |2 | 2<BR /> mango|1 | 1<BR /> mango|2 |2</STRONG> </P> <P>To look something like this:</P> <P><STRONG>Fruit | count<BR /> apple | 5<BR /> mango | 3</STRONG></P> <P>Thank you.</P> Thu, 26 Sep 2019 13:33:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-add-two-rows-to-one/m-p/486359#M136062 mmengu416 2019-09-26T13:33:04Z https://community.splunk.com/t5/Splunk-Search/How-to-add-two-rows-to-one/m-p/486360#M136063 <P>Try this!</P> <PRE><CODE>(your search) |stats sum(count) as count by Fruit </CODE></PRE> Thu, 26 Sep 2019 14:34:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-add-two-rows-to-one/m-p/486360#M136063 HiroshiSatoh 2019-09-26T14:34:41Z