*Display* top x records only in report, but aggregate all records

[dmusson17]

Hello all,

We would like to set up a simple list report that displays only the top 10 records, but considers all records in the aggregation/summary line.  For example, i want to see the top three orders by volume, but have all orders show in summary:

Order 1, $100, 5% of overall volume
Order 2, $50, 2.5% of overall volume
Order 3, $10, 1% or overall volume

Summary line:  $2,000, 100% of overall volume

Tried using rank, but this filters out the remaining rows so they don't show in the summary.

Thanks for any direction!

[MFGF]

Hello all,

We would like to set up a simple list report that displays only the top 10 records, but considers all records in the aggregation/summary line.  For example, i want to see the top three orders by volume, but have all orders show in summary:

Order 1, $100, 5% of overall volume
Order 2, $50, 2.5% of overall volume
Order 3, $10, 1% or overall volume

Summary line:  $2,000, 100% of overall volume

Tried using rank, but this filters out the remaining rows so they don't show in the summary.

Thanks for any direction!

Hi,

Use rank - as you have been doing - but instead of filtering on this directly, add another calculation that has syntax similar to:

if ([your rank item] <= 3) then ('Best') else ('Rest')

You can then group the list on this and add aggregates to the measure(s) to get group footings. Finally, use a boolean variable with the expression [your calculation] = 'Rest' and use this to conditionally hide the "Rest" rows within your list.

Cheers!

MF.

[dmusson17]

Thanks so much!  Worked like a charm.