Pivot table total row incorrect calculation in ratio

Q&A
, ,
1

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.
image

Thank you all!

2

Can column c be a calculated field that is sum(a)/sum(b)?

3

that what it is, just it the total its doesn’t work that way.

4

I mean this.

image

1 Like
5

Hi @hillel.bendkowski, Did Max’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!