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