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.