adding a dummy row

[kajolsharma]

Hi , I want to add a row total=0 in the below table .Can somebody suggest?

kajolsharma_0-1631028313227.png

query used is:  index="monthend" source="Period End Tracker_6Sep'21.csv"|rename "Activity Name" as Activity|dedup Activity|eval status_1=if(Activity=="Month End Closing for AP,AR & GL","Delay","On Track")|stats count by status_1

[ITWhisperer]

| append [| makeresults
  | eval status_1="Total"
  | eval count=0]

[kajolsharma]

Here i m getting count as 0 .Wat if I want the actual count of below statuses :-

kajolsharma_0-1634714910938.png

query used - |inputlookup append=t Month_End_Tracker.csv|dedup "Activity Name"|stats count by Status|append [| makeresults
| eval Status="Total"
| eval count=0]|table Status count

[ITWhisperer]

| addcoltotals labelfield=Status label=Total