Problem excluding 'Others' in subtotal after applying Top N sort
Hi all, question from a newby.
My V8.5 Crystal report has two levels of grouping, Store and Brand with expense $ values subtotalled for each level. I am only interested in the Top 10 Stores per Brand so have used the Top N/Sort Group Expert so that only the top 10 Stores are shown. The problem is the subtotal for each Brand totals all the stores instead of just the top 10. I have not ticked the 'include others' box. How can I get the subtotal exclusive of the other stores?
Any help much appreciated,