Sorting without including total row
I have a table, showing revenue with countries. I need to show total revenue amount at bottom of the table along sorting revenue in descending order i.e., I want to see revenue of countries order by revenue showing Total row at the bottom.
Is it possible through SQL or any other way?
Hi Komal Chouhan - thanks for writing in. Yes, this can be accomplished within your SQL query by UNION'ing the appropriately grouped columns. I've created an example report for you to see how it's done here:
Also, as another possible option, once you've added a table to your report, you can integrate a totals row at the bottom. For more information on this approach, please check out Mode's Gallery example: https://mode.com/resources/example-gallery/totals-at-bottom-of-table/
Hope that helps - please let our success team know via in-product chat or firstname.lastname@example.org if you have any other questions. Thanks!