The amount of the filtered group in SSRS

Question

I applied the Top N filter in the "Purchase_Amount" group to get only the top N values ​​of the group, but when I apply Sum to the group

=Sum(Fields!Purchase.Value, "Purchase_Amount") 

which give me the sum of the entire data set, so how can I get the sum of the filtered group?

Answer 1

There are many ways to solve this problem. I would suggest that the filter will move the data stream either to the query or to the properties of the dataset.

But some other methods are described in this thread of the MSDN community: Either create a fake shared line inside the group members that contains the function =RunningValue(...) , and set the visibility only to be displayed on the last line; or refer to another page element where you can only get the total number of filtered elements.

Answer 2

You can try installing a filter in your tablix instead of a group - any amounts in tablix are then subject to this filter.