Good day !! I have a use case where I need to compare sales amount of different categories against sales of a particular category and it should be interacting with the Slicers present in the analysis as well.
For Example, I have a Category column comprising values like Furniture, Technology, Finance etc. I have couple of other columns like Region (having values like East, West, Central etc.) and Sales amount.
There are couple of slicers in the analysis - one for choosing category and other for choosing Region
The data table contains only 3 columns Category, Sales and Furniture Sales. The expectation if when the user will choose a category (say Technology) and Region (East and Central) the Table will show Total Technology Sales (“Technology” is chosen from Category Slicer and Sales are comprising of East and Central which are chosen from Region Slicer) and Total furniture Sales (“Furniture” is pre-decided and fixed and Sales are comprising of East and Central which are chosen from Region Slicer)
However, I am unable to achieve this. I am providing the calculation of the Furniture Sales column and other related details in the snapshot below for better understanding.
Looking forward to response, suggestions and guidance from all the Quicksight LAA / LAC Experts. Thank you!