How to Handle different levels of granularity in Amazon Quicksight

I have created a pivot table in my dashboard. As you can see below dashboard is showing the Sales by Sub-Category level.

I want to see the Each Category Sales by using the calculated field. For example, Furniture category sales is 9860. and it would repeat for Furniture category.

I want to do this by calculated field. Basically I want to handle the different level of data granularity How can I do this ?

NOTE : Tableau has LOD (Level of Details) function for this type of calculations.



Thank you for posting your question.

Level Aware Calculations on Amazon QuickSight will help with your question above.

Please do review the link below for an exercise on how to.



1 Like

Thanks for the reply @demola