Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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,

Jan

replied

use manual running totals to calculate the value, it should only pick up on the top 10, not all values

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question