Hello everyone,
Thanks for reading, my english is not good at all.
I have this:
A | B | C | D | E | F | G |
1 | 1 | 0 | 4 | 1 | 0 | 0 |
1 | 2 | 0 | 2 | 2 | 0 | 9 |
0 | 0 | 0 | 1 | 3 | 0 | 8 |
0 | 1 | 0 | 0 | 4 | 0 | 9 |
0 | 0 | 0 | 9 | 5 | 0 | 0 |
0 | 0 | 0 | 8 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 1 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 |
So, i need sum all value of each column
I would like to have this:
Column | sum |
A | 2 |
B | 4 |
C | 0 |
D | 24 |
E | 15 |
F | 1 |
G | 26 |
Hi @HideOnCode82,
what is your search? could you share it?
Anyway, see the addcoltotals command (https://docs.splunk.com/Documentation/Splunk/8.2.5/SearchReference/Addcoltotals) to have the sums you need at the bottom of your table.
If instead you want only the total row reversed, it's possible but you have to work a little, if you could share your search I could help you.
Ciao.
Giuseppe
Hi @HideOnCode82,
what is your search? could you share it?
Anyway, see the addcoltotals command (https://docs.splunk.com/Documentation/Splunk/8.2.5/SearchReference/Addcoltotals) to have the sums you need at the bottom of your table.
If instead you want only the total row reversed, it's possible but you have to work a little, if you could share your search I could help you.
Ciao.
Giuseppe
Thanks you so much!!!
It worked perfect!