Hi all! I have not perfect dataset, with duplicated values. This is example of what i have and what i need: [image] To get correct SUM of revenue, first i need get MAX(or min, the values are same inside group) grouping by Company and Division, and only after that i can SUM this values to get cor…

[image] iskorokhid: To get correct SUM of revenue, first i need get MAX(or min, the values are same inside group) grouping by Company and Division, and only after that i can SUM this values to get correct result. Based on this description, the following calculated field should work for you: s…

Hi @iskorokhid you can use MAX() or AVG(). avgOver - Amazon QuickSight The avgOver function calculates the average of a measure partitioned by a list of dimensions. Something like. avgOver(max({Revenue}),[{Company},{Devision}]) On company level it will b…

[image] ErikG: avgOver(max({Revenue}),[{Company},{Devision}]) Thank for feedback! I tried SumOver before, here your sample: [image] SumOver works only if i put field, that i use in formula to table, but it’s not working when i use 1 field, or some other fields. Is there a solution to show…

What if changing the aggregation of Revenue? [grafik]

If you mean just make revenue as MAX - it will show Max value, SumOver has custom aggregation so it’s not possible to change it. [image]

i mean in Rows “Company” and “Division” and Value Revenue(max)

In the end I don’t need any rows, i need measure that can work without that columns, for example - to use it in KPI chart: [image] Looks like it’s not possible in Quick Sight, or i can’t find how to do that trick : (

That’s why i liked your post in another topic! It’s works and it’s pure magic : ) Thanks a lot!

@iskorokhid , I’m glad it worked. You can read more about how to deduplicate data here: [image] Level-Aware Calculations: Tips and Best Practices Articles [Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us t…

I’ve been banging my head against the wall for 3 days trying to find a solution to this exact problem. In the end, so simple. :slight_smile: Thank you!

Summarize Max value over group

Q&A

David_Wong October 27, 2023, 2:56pm 10

@iskorokhid, I’m glad it worked.

You can read more about how to deduplicate data here:

Topic		Replies	Views
Sum of MaxOver calculated field Q&A quick-sight , Business-Intelligence-Engineer	5	61	March 4, 2025
Take max value by partition and then sum the max value of each partition Q&A quick-sight , calculations , Business-Intelligence-Engineer	7	2597	November 14, 2023
Comparing Maximum Values using maxOver() Q&A feature-request , quick-sight , calculations , Business-Intelligence-Engineer	7	74	March 24, 2025
Show total despite using 'group by' field in Table visual Q&A developer , quick-sight , qls-community	7	96	August 27, 2025
Mismatched aggregation with max and sum Q&A developer , error , quick-sight	2	33	July 15, 2025

Summarize Max value over group

Related topics