Hello, is there a way to get the total revenue i-e in metrics sum of any column value.

Hi @creamy-airplane-54238 Yes, you can get total revenue by defining a Mean metric on your revenue column with aggregation set to

SUM(column)

on your orders/purchases Fact Table. This will sum revenue per user and then report the average per user in experiment results. https://docs.growthbook.io/app/metrics#mean-metrics

Yes, I do use that, but that is still average revenue per user. I need the total revenue (sum of all rows)

Ah yes, the default aggregation is on a per-user basis in the Results table, even when you define a Mean metric with

SUM(column)

There isn’t a built‑in way to display “total revenue” per variation directly. To get total revenue (sum over all users/rows), you’d need to run a custom query in your warehouse using the same fact table and filters as the metric

yeah got it! It does show you the value of numerator (total revenue in this case) when using sum per user. So one can observe the numbers from GB dashboard too