Add a Grand Total Row at the end of table while creating dashboard

I am using Metabase to create various dashboards. I am facing problem in getting the grand total as a separate row at the end of every table with total sum/total count of a particular columns.
Please find the attached image of a dashboard for which I need to get the grand total of (total_pos)

Sample Example

Product Amount(in INR)
Mobile 50,000
TV 80,000
WM 20,000

Grand Total 1,50,000 (How to get this row line item)

image

Hi @abhi1986

That’s available with Pivot Tables in 0.38 - but not for SQL and a few other limitations:
https://www.metabase.com/blog/Metabase-0.38/index.html

There’s a request for having a frontend option:
https://github.com/metabase/metabase/issues/3218 - upvote by clicking :+1: on the first post

Depending on your database type, you might have access to ROLLUP, example:

SELECT IFNULL(CATEGORY, 'Grand Total'), SUM(PRICE)
FROM PRODUCTS
GROUP BY CATEGORY WITH ROLLUP;

Currently we are using 0.37 version of Metabase. Is 0.38 stable version and can be used in production deployment?

@abhi1986 0.38.0 is fully released and being used in production. Always have backups before upgrading, so you can revert in case you’re having problems with a specific version.