Hi,
My data is in below format
I am trying to add the total of all the columns and show it as below
Please help me on how can i achieve this and also i am trying to sort by rename 1 2 as JAN FEB so on but after renaming it is sorting by alphabetical order. How can i sort based on month wise?
1. Use addttotals. Since you probably don't want totals column-wise, use col=false
2. At the end of your search (after rename and all calculations), add
| table CURRENCY Jan Feb [...] Total
Depending on the number of rows you have, transpose might be another solution
| transpose 0 header_field=CURRENCY column_name=CURRENCY
| sort 0 CURRENCY
| eval CURRENCY=strftime(strptime("2022-".CURRENCY."-1","%Y-%m-%d"),"%b")
| transpose 0 header_field=CURRENCY column_name=CURRENCY
| addtotals col=f
1. Use addttotals. Since you probably don't want totals column-wise, use col=false
2. At the end of your search (after rename and all calculations), add
| table CURRENCY Jan Feb [...] Total
@PickleRick Thank You, it worked fine.
Could you please help me with one more solution
I am appending the 3 results and now how do i add the total of 3 results.
Now you do need the column-wise totals. So just do col=true (or don't specify it at all - true is the default setting if I remember correctly)