https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470907#M132474 <P>Try this</P> <PRE><CODE>index=aos_transaction | chart count by payments, geo | addtotals | sort -Total | head 10 </CODE></PRE> Tue, 03 Sep 2019 20:09:53 GMT somesoni2 2019-09-03T20:09:53Z https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470906#M132473 <P>index=aos_transaction<BR /><BR /> | chart count by payments, geo<BR /> | addtotals col=t<BR /> | sort -Total<BR /> | head 10</P> <P>I want to display only top 10 payments with geo breakdown. when I use the above command my total is also showing in the bar chat.</P> Tue, 03 Sep 2019 19:53:21 GMT https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470906#M132473 sandeepmakkena 2019-09-03T19:53:21Z https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470907#M132474 <P>Try this</P> <PRE><CODE>index=aos_transaction | chart count by payments, geo | addtotals | sort -Total | head 10 </CODE></PRE> Tue, 03 Sep 2019 20:09:53 GMT https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470907#M132474 somesoni2 2019-09-03T20:09:53Z https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470908#M132475 <P>I alredy tried that but, the problem is when displaying as chart it is including total in the chart. I just want it to be used for sorting. </P> Wed, 04 Sep 2019 00:32:26 GMT https://community.splunk.com/t5/Splunk-Search/Chart-command/m-p/470908#M132475 sandeepmakkena 2019-09-04T00:32:26Z