Skip to Content
0
Former Member
Nov 05, 2009 at 09:59 PM

Summarizing Total on Top N

64 Views

Hello,

I have a report with (for argument's sake) 100 records. I am using the Group Sort Expert so the report only shows the Top 20 records based on revenue.

I also have two groups one by country and one by region with their corresponding summaries (sum of Command.Revenue). Each shows a Grand Total in Revenue of all 100 records. Which is fine. I need this.

Now I want to also total the Top 20 only...how do I do that? I haven't been able to figure out how to run a total on just the Top N.

Thank you,

Sorell