This article explains Amazon QuickSight's new Level-Aware Calculations (LAC) feature for advanced data analytics and aggregations.

• LAC enables specifying custom granularity for aggregate and window functions independently
• LAC-A functions allow nested aggregations with custom group-by dimensions
• LAC-W functions are existing window functions with PRE_FILTER or PRE_AGG stage options
• Use case 1: Compare individual orders to product-level average quantities
• Use case 2: Calculate region averages from country-level sales aggregations
• Use case 3: Handle denormalized datasets with duplicate rows using LAC
• Dynamic group keys allow reusing LAC expressions across multiple visuals automatically
• Use case 4: Calculate customer average sales within regions or countries dynamically
• Use case 5: Calculate subregion sales percentage relative to region totals

LAC simplifies complex calculations without requiring pre-aggregated tables or data preparation, now generally available in all QuickSight regions.