Skip to Content
0
Former Member
Sep 19, 2008 at 01:21 AM

Problem excluding 'Others' in subtotal after applying Top N sort

32 Views

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,

Jan