Hi Nobert and Joe,
Thank you for helping me.
@Nobert - Your file seems to give the right result and that is what is expected from my dashboard.
I have attached the workbook with dummy data. It seems to work with this dummy data, however, the top condition filter is not displaying some cases with my original data.
Would it be possible for you to go through the attached file and see if the condition applied is current.
Checked the file but not able to validate based on 20 rows for which all dates (Incident, Creation, etc) are set to 8-2-1013. Please provide a bigger dummy data with dates through the year.
Hope to hear from you soon.
Have a nice weekend.
1 of 1 people found this helpful
Thanks for looking into the file.
Below are the steps that seem to have solved my problem:
- I created a calculated field using index() function.
- Sorted the Specific category on the number of cases.And I applied a filter on that to show top 10 values.
- And then I applied a filter on the index to show top 10 values.
Thanks for your help!