View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
I had a Client recently that wanted to show the top N of a query on a report and have the rest separated into another group. The top N is easy but the bottom N would changed based on the number of rows in the query. So I had to figure out a way to calculate this number. I created two groups on the report. The first I placed a filter of “top 10”.
In the second group I placed a filter of bottom N, but I had to calculate the N by subtracting the count of the rows in the dataset.
I used the count function on a field in the dataset and subtracted 10 to remove the top 10 rows. So the results look like so:
Other posts by MikeDavis