Question on grouping

[dzavad]

I have a question on grouping. I’ve made a report with a group, "Area of Concern" and I’ve put a cross tab in that group showing the specifics for each "Area". it shows access areas, for Billing; billing areas, Security; security issues and so on.

What I’d like to do is just show the top five groups and the groups can change by other parameters. This way only the important groups are shown and not the lower important ones. Is there a formula that can go in and determine the Top 5 of any field based on a criteria?

 

[lbass]

Please tell us what your column and row fields are within the crosstab and what the summary(ies) is/are. Can't tell whether you are trying to limit the number of row groups or the number of summary results displayed per cell.

If you are trying to limit the number of rows to the topN using some summary, you can click on the upper left (empty) corner of the crosstab->go to the report tab->topN/group sort and choose the summary you want to use for the topN group sort. The sort will be based on the row total field.

If you are trying to display the top values per summary per cell, you can add one of the "NthMost..." type of summaries multiple times, incrementing N by 1 until you have N = 5.

-LB

 

[dzavad]

What I’d like to do is show only the top 5 groups and the groups can change by other parameters. Is there a formula that can go in and determine the Top 5 of any field based on a criteria

 

[lbass]

Use the topN/group sort method that I described.

-LB

 

[dzavad]

thank you it worked great.