I have created an aggregate value like Total -Sales: sum(max({Sales}, [{Region}, date])) . I want to create one more calculated field that uses the total of (Total-Sales) as a denominator for another KPI. Further this denominator should change dynamically , like if i select two countries the value …

Can you share the sumOver that’s giving you an error? Use case #4 in this article covers percentage of total calculations. Let me know if that helps. [image] Level-Aware Calculations: Tips and Best Practices Articles [Level-Aware Calculations in Amazon QuickSight] Level-…