topic Re: Splunk Statistics table with totals column in Splunk Search https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325906#M97158 <P>Worked like a charm....<BR /> Thanks Ssievert</P> Thu, 07 Sep 2017 18:49:18 GMT jackson1990 2017-09-07T18:49:18Z Splunk Statistics table with totals column https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325904#M97156 <P><STRONG>Below is my CSV Data :</STRONG></P> <HR /> <P>Company, Model,Year<BR /> Honda, Civic, 2016<BR /> Toyota, Camry, 2017<BR /> Honda, Accord, 2016<BR /> Honda, Civic SE,2017<BR /> Honda, Fit, 2017<BR /> Honda, Fit EV, 2017<BR /> Toyota, Corolla, 2016</P> <H2>Toyota, Yaris, 2017</H2> <P>The fields auto extracted by splunk are Company,Model and Year.<BR /> When i make a "chart count over Company by Year | addtotals " and change to statistics table in Splunk simple xml Dashboard visualizations,i get the result as <BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/3472i245B70692D13AECE/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>My requirement is to get the totals field as second column.</P> <P><STRONG>Expected:</STRONG><BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/3473i17D1FEE0B2C08F01/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>IF not possible through the above way,kindly suggest a way to achieve the expected stats table,with total field as second column.<BR /> Thanks in Advance</P> Thu, 07 Sep 2017 17:35:10 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325904#M97156 jackson1990 2017-09-07T17:35:10Z Re: Splunk Statistics table with totals column https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325905#M97157 <P>Try this: <CODE>chart count over Company by Year | addtotals | fields Company, Total, *</CODE></P> Thu, 07 Sep 2017 17:45:31 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325905#M97157 s2_splunk 2017-09-07T17:45:31Z Re: Splunk Statistics table with totals column https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325906#M97158 <P>Worked like a charm....<BR /> Thanks Ssievert</P> Thu, 07 Sep 2017 18:49:18 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-Statistics-table-with-totals-column/m-p/325906#M97158 jackson1990 2017-09-07T18:49:18Z