Description - Currently there is the ability to use an advanced function "column sum" in calculated metrics. This adds up the value of all the rows in the dimension and gives a sum. The issue with this is that the number is often different from the 'grand total' at the top of the column of the original metric. This is because the grand total is deduplicating items by default, but the column sum doesn't do the deduplication. For example, if your dimension is products and your metric is orders, the grand total will give you the total number of orders and each row will give you the number of orders for that row. The column sum will add up each of those rows, ignoring the fact that a single order can have more than one product, and give you a sum that overcounts the actual total. To fix this, create a new function that is a grand total, it will take the grand total value associated with the dimension it is put against.
Why is this feature important to you - This is important because it provides increased functionality when creating advanced metrics that need to use a total for the entire column. The column sum is great, but it is limited, and this would remove that limitation.
How would you like the feature to work - The grand total function would be able to be added to metrics like all of the other functions. What it would do is take the grand total (a deduplicated total) associated with a metric.
Current Behaviour - Currently there is no option for a grand total function, only a column sum.
