Collapsing pivot table shows null for YoY

[neelay]

@Krisztian_Nemeth

These 2 articles will help you understand the level aware calculation in QS.

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…

Level aware sum / sumOver problem

@Kristin @David_Wong I hope both of you get everything from this [image] BTW, all 4 pie charts are wrong, though 1st is showing the expected result, the other 3 are wrong as well as showing the unexpected result. We already went through sum(sumover()) example… So I didn’t include them in the screenshot.

most probably you will find your answer here… Let us know if you still have any questions.