Ssrs Display Top N But Have Sum Include All Values

I currently have a tabllix in SSRS with multiple rows, but I wish to only display the top 5 rows, yet have the total column at the bottom include the values for however many rows a

Solution 1:

Add a rownumber column to your query (SQL)

ROW_NUMBER() OVER (partition BY FIeldName1 ORDER BY FieldName1 Asc) AS rownum

On the Report:

• Right click on any Tablix column and select Tablix Properties
• Click on Filters

Expression: rownum

Operator: <

Value: 6

Solution 2:

You can use Top N to do this. Look 'How to get total of top 10 sales in SSRS 2012'