Tuesday, August 28, 2012

How to limit the number of records in a report?

1. Create a metric with definition Max(1) - Max
2. Create another metric on top of this metric Max- RunningSum(Max)
3.With the report open, add a report limit against the Running Sum metric so it only returns top five row's records.
To achieve this, go to Data > Report Data Options > Report Limit> Modify to specify the report limit definition -Rank(RunningSum) Top 5

No comments:

Post a Comment