Definitely a workbook is needed to help you here.
sad thing , i cant shar it
Don't worry it can be done on Tableau and is more simple that you can imagine, you will need something that well, not much people use, and that is the use of 'Sets' so what we will do is to create a dynamic set that contains the top 5 complains or prod cat by countd(case id). So, let's start!
- First create the set (I'll use super store)
2. Create the condition
3. Create the Calculated field (the set is a boolean)
4. Drag the new calculated field into the column/row shelf
5. Repeat for the other dimension and that's it
Please, tell me if it worked for you!
your reply is really helpful, i am struggling with this for few days.
you just simplified my work .
thanks a lot!!