Hi all.

I have a visual with some dimensions and 3 metrics:

Column A- values wish SUM aggregation function.

Column B- values wish SUM aggregation function.

Column c= column A /column B = the ration between them.

For all row the calculation works perfectly, the problems are Total and Subtotal.

It calculates for column C the aggregation function defined on column C (which is AVG) or Sum of all ration instead of what I really need: the ratio of total column A and total of column B.

Thank you all!