Top N summary 1

[ddrake]

Hi,
I've got a report that displays the Top 10 of a particular grouping. For example, of a dataset of 100 entries all with different categories, I've grouped by that category field and I'm displaying only the top 10 results based on summaries of each category:

1. Category 1 - 10 records
2. Category 2 - 9 records
3. Category 3 - 8 records
4. Category 4 - 7 records
5. Etc.....

There are a number of records left over that are not displayed as part of the top 10.

My question is how can I get a total of just those top 10 without including the rest of the dataset?

 

[lbass]

Create two formulas:

//{@accumtopN} to be placed in the group header or footer:
whileprintingrecords;
numbervar sumtopN;
numbervar counter := counter + 1;

if counter <= 10 then
sumtopN := sumtopN + sum ({table.amt},{table.category});

//{@displaysumtopN} to be placed in the report footer:
whileprintingrecords;
numbervar sumtopN;

-LB

 

[ddrake]

Thank YOU

 

[ddrake]

If I place the second formula in the Report Footer it works beautifully. When I place it in the Report Header however, it displays 0. How could I modify the second formula to be appropriately displayed in the report header instead?

Thanks!

 

[lbass]

To get this number in the report header, I think you would have to save the report under a different name, and insert the newly named report as a subreport in the report header of the original subreport, suppressing all subreport sections except the subreport footer.

-LB

 

[ddrake]

Brilliant! Thanks a lot!

 

[vblack7770]

How do I get a total of just top 10?

 

[lbass]

That's what my first post describes, assuming you have already used the topN/group sort.

-LB