Am getting data in this format now.
but i need to show only those row where sum of all column values are > 500
am trying somethign like this. am new so unable to form the query, please help
its working now! Appreciate!
If the existing columns are what you initial expect before your >500 test, then simply add the following to the end of your query
| addtotals
| where Total>500
| fields - Total
If it works for you, please mark the question as solved, so others can benefit