SSRS – Microsoft sql server fitler table/matrix with 2nd row of data
What I wanted to do, was to create multiple table/matrix, but to have them separate. And then to have 5 of them in total. But I wanted to have the top 5. So I wanted the first one to be the top value, then top 2, top 3, top 4 and top 5.
This is what the result looks like:
1. Create your first table/matrix which will be filtered as shown below:
2. Then copy and paste your first table/matrix and complete the filter like this to show ONLY the second one or top 2
b. The thing to note here is that for the Top N value I put 2
c. And then for the Bottom N I put 1
3. Then to do this for the third or top 3, do the following:
a. Copy the above table/matrix and complete the filter as follows:
c. The thing to note here is that the Top N was changed to 3
4. NOTE: For any additional table/matrix change the top N to the value you want.