Grouping and Top Records

fiber0pti

I have a tabular report where I'm grouping by a specific field, state. I want to return the top 5 records (based on a field called amount) for each state. Is there a way to do this?

I've tried adding a filter to the group using the Top N filter and it doesn't seem to work.

Virgil Dodson

Hi fiber0pti,

I see the same thing when trying to filter on the group using the TOP N operator. One alternative to make this work is to use a nested table instead of a group. Enclosed is a simple example that does this.