Pivot table Aggregation

[Brett]

Hi @liya101,
I replied to your other topic regarding different aggregation levels in a pivot table and the restrictions with that.
Calculated fields cannot be built on different aggregation levels either, you’ll encounter mismatched aggregation errors.
Here is a great article that explores level aware calculations a bit further and helps with aggregations:

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…

Let me know if you have any additional questions