@Kirthika  This will eliminate the last result assuming your data is in descending order of Count | makeresults ``` Replicating your results ``` | eval Count="1,2,3,4,5,6" | eval Count=split(Count,",") | mvexpand Count | eval error_manager = "System" | table Count error_manager ``` excluding or "deleting" 6 ``` |eventstats |eval LastCount = 'max(Count)' |where 'Count'!='LastCount' |table Count error_manager   ... View more

Hi @Kirthika , In order to remove 6 from the table we must exclude it, this could be done using either |where or |search , here's my example using search: | makeresults ``` Replicating your results ``` | eval Count="1,2,3,4,5,6" | eval Count=split(Count,",") | mvexpand Count | eval error_manager = "System" | table Count error_manager ``` excluding or "deleting" 6 ``` |search NOT Count = 6 Count error_manager 1 System 2 System 3 System 4 System 5 System ... View more