https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-of-the-two-count-values/m-p/643019#M222727 <P>I am using above splunk query&nbsp; &nbsp;stats count by BankType.</P> <P>&nbsp;I am getting result as&nbsp;</P> <P>&nbsp;SBI&nbsp; &nbsp;27</P> <P>AXIS&nbsp; &nbsp;15</P> <P>CITI&nbsp; &nbsp;12.</P> <P>but I want to sum the count of Axis and citi and&nbsp; display it under AXIS column. so basically output would be something like this&nbsp;</P> <P>SBI 27</P> <P>AXIS 27.</P> <P>Can anyone suggest what can we do here ?</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 11 May 2023 11:28:52 GMT ABHAYA 2023-05-11T11:28:52Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-of-the-two-count-values/m-p/643019#M222727 <P>I am using above splunk query&nbsp; &nbsp;stats count by BankType.</P> <P>&nbsp;I am getting result as&nbsp;</P> <P>&nbsp;SBI&nbsp; &nbsp;27</P> <P>AXIS&nbsp; &nbsp;15</P> <P>CITI&nbsp; &nbsp;12.</P> <P>but I want to sum the count of Axis and citi and&nbsp; display it under AXIS column. so basically output would be something like this&nbsp;</P> <P>SBI 27</P> <P>AXIS 27.</P> <P>Can anyone suggest what can we do here ?</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 11 May 2023 11:28:52 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-of-the-two-count-values/m-p/643019#M222727 ABHAYA 2023-05-11T11:28:52Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-of-the-two-count-values/m-p/643024#M222732 <LI-CODE lang="markup">| eval BankType=if(BankType=="CITI", "AXIS", BankType) | stats count by BankType</LI-CODE> Thu, 11 May 2023 11:41:15 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-of-the-two-count-values/m-p/643024#M222732 ITWhisperer 2023-05-11T11:41:15Z