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!!
I am having one more issue with this top 5 and all others..
current month volume its giving perfect, but when i am trying show the details in a year, each individual month is not displaying what expected ,
unfortunately i will not be able to share the workbook, attaching the screen shots.
if you observe the below screen in feb i dont have all other group , but in total percentage it has an entry and reason category is limitng to first month values and then giving values for other months ...hope you can help me out here.
Jan month count