https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372042#M109455 <P>Hi </P> <P>I have a table as below. </P> <P>severity S0 S1 S2 S3<BR /> event A 1 0 0 0<BR /> event B 0 2 0 0<BR /> event C 0 1 1 0 </P> <P>each column has different weight. for example S0 = 1,000,000, S1 = 10,000, S2 = 100, S3 = 1. i want to sort the event based on the weight multiply by the event number. <BR /> Please advise.</P> Wed, 10 May 2017 14:59:00 GMT hakusama1024 2017-05-10T14:59:00Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372042#M109455 <P>Hi </P> <P>I have a table as below. </P> <P>severity S0 S1 S2 S3<BR /> event A 1 0 0 0<BR /> event B 0 2 0 0<BR /> event C 0 1 1 0 </P> <P>each column has different weight. for example S0 = 1,000,000, S1 = 10,000, S2 = 100, S3 = 1. i want to sort the event based on the weight multiply by the event number. <BR /> Please advise.</P> Wed, 10 May 2017 14:59:00 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372042#M109455 hakusama1024 2017-05-10T14:59:00Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372043#M109456 <P>try this:</P> <P>| eval weight=(S0*1000000 + S1*10000 + S2*100 + S3*1)<BR /> | sort 0 - weight</P> Tue, 29 Sep 2020 14:00:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372043#M109456 HeinzWaescher 2020-09-29T14:00:47Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372044#M109457 <P>thank you sir. </P> Wed, 10 May 2017 15:38:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-row-sum-which-each-column-has-different-weight/m-p/372044#M109457 hakusama1024 2017-05-10T15:38:04Z