https://community.splunk.com/t5/Splunk-Enterprise/table-with-eventstats/m-p/394297#M1254 <P>This should work:</P> <P>| stats count sum(TOTAL_SHIPPED) by TYPE</P> Sun, 17 Jun 2018 15:55:55 GMT FrankVl 2018-06-17T15:55:55Z https://community.splunk.com/t5/Splunk-Enterprise/table-with-eventstats/m-p/394296#M1253 <P>So this is example data</P> <P>TYPE, COUNTRY , TOTAL_SHIPPED<BR /> Orange, US, 25<BR /> Apple, US , 100<BR /> Apple , UK , 25<BR /><BR /> Orange, SPAIN , 10<BR /><BR /> Pears , GERMANY , 10</P> <P>I want to bring back a table that counts the number of Orange Types of there and bring back the SUM of "total_shipped"</P> <P>So that I get</P> <P>TYPE, Count( TYPE), SUM()TOTAL_SHIPPED<BR /> Orange, 2 , 30<BR /> Apple , 2 , 125<BR /> Pears , 1 , 10</P> Sun, 17 Jun 2018 15:02:10 GMT https://community.splunk.com/t5/Splunk-Enterprise/table-with-eventstats/m-p/394296#M1253 TCK101 2018-06-17T15:02:10Z https://community.splunk.com/t5/Splunk-Enterprise/table-with-eventstats/m-p/394297#M1254 <P>This should work:</P> <P>| stats count sum(TOTAL_SHIPPED) by TYPE</P> Sun, 17 Jun 2018 15:55:55 GMT https://community.splunk.com/t5/Splunk-Enterprise/table-with-eventstats/m-p/394297#M1254 FrankVl 2018-06-17T15:55:55Z