Grouping and Top Records

fiber0ptifiber0pti Junior Member
edited December 31, 1969 in Designing Analytics Reports
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.

Comments

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    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.

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

Sign In or Register to comment.