How to get total for top n rows (not for whole dataset) in SSRS 2017

Question

I need to get SUM for TOP 10 rows only by counting unique claim numbers. Not for the whole dataset.

for that in a group properties I set Filter with expression:

But the total sum reflected for the whole dataset, not for top 10.

I tried using RunningValue finction, but no success:

What would be the way to capture sum for only top 10 rows?

score 0 · Answer 1 · answered May 26 '20 at 18:30

Create row inside the group 2.Enter expression referencing dataset name (not group name):

=RunningValue(Fields!IdemnityReserves.Value,SUM,"UnitedSpecialty")
Make this row invisible
Add total row
Enter expression in total row referencing cell created in step 2:

=reportitems!Textbox288.Value

1 Answers1