Level calc difficulty

[Brett]

Hi @karvsha,
Here’s a great article that explores level aware calculations that can help alleviate mismatched aggregation errors:

Level-Aware Calculations: Tips and Best Practices

[Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…

You may want to look in to utilizing the sumOver function instead.

Let us know if you have any additional questions