Quicksight - Total line in Table to show Sum of Max values from each row

Question

Hi All,
I have a data set in which I have to use the "max" function in displaying a particular measure (i.e. not sum) but I need the Total line to show the sum of the max values coming from each row.
In Excel, a pivot table can do that, i.e. a measure in max function in the table can still be summed in the total line.
In Quicksight, Total line gives me the max of all the max values it finds in the table
Is this possible in Quicksight? i.e. controlling what the Total line should show for a measure?

Accepted Answer

You could create a calculated field and use the [sumOver function ](https://docs.aws.amazon.com/quicksight/latest/user/sumOver-function.html).

the measure would be the aggregated value you are looking for (max in your case), partition by the dimension in the pivot and you can leave blank the third parameter (the default is **POST_AGG_FILTER** that is what you are looking for).

Using QuickSight samples **Sales Pipeline analysis** the calculated field (max_revenue) would be:

```
sumOver(max({Weighted Revenue}),[Region])
```

the result would look like the pivot table on the right in [this screenshot](https://fna-web-hosted-content.s3.amazonaws.com/rePostimages/Screen+Shot+2022-01-07+at+5.17.44+PM.png).

Answer

Thank you very much for this. This was exactly what I needed

Quicksight - Total line in Table to show Sum of Max values from each row

相關內容