Configure report to show only Top 5

[mint]

Hi all, I am trying to create a report as bar chart to show the top 5 categories with the highest number of incidents occurring in the past 30 days.

However, it only allows you to select the minimum of top 10 (via "No. of group" field). Does anyone know how to set this?

Or if I want to configure it as a "List" (table list), is there anyway I can add a calculated field to count the number of incidents occurred per each category? So then I can sort the list by the number of incidents occurred per category, and it can also be exported out as Excel file which I can further work on it.

Thank you!

[Malaya]

thanks much for the solutions.. it's exactly what i was looking for.

Thanks,

Malaya

[Carl Fransen1]

Hi - could you mark this as having a correct answer - to allow future searches to show this as answered!

[andrew_e]

You da man Michael! This was just what I needed.

[hollye]

I'm confused. Where do we do this at? I have a stacked bar chart and would like to show just the top 5 categories for each manager, is this possible?