Amazon QuickSight launches Level Aware Calculations that allow you to derive advanced analytical insights independent of aggregations and filters applied on your charts. These are calculations that can be computed at a desired level in the overall query evaluation order of QuickSight. You can answer questions such as “How many customers have made one, two, three orders?”, “What is the contribution of each industry to the entire company’s profit irrespective of the filters applied?”. See the blog here to get started with Level Aware Aggregations.
Source:: Amazon AWS