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!
Quote from: dmusson17 on 01 Aug 2014 11:46:35 AM
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.
Thanks so much! Worked like a charm.