CODEWITHSUNDEEP
sql-serverreporting-services
Yogesh
Yogesh

Reputation: 3482

Sum of filtered group in SSRS

I have applied Top N filter on 'Purchase_Amount' group so that i can get only Top N values of group but when i am applying Sum on group 

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

that give me sum of whole dataset so how can i get sum of filtered group ?

Upvotes: 11

Views: 18889

Answers (2)

Moby Duck
Moby Duck

Reputation: 2090

You could try setting the filter on your tablix instead of the group - any sums in the tablix are then subject to that filter.

Tablix Properties

Upvotes: 12

Jamie F
Jamie F

Reputation: 23789

There are many ways to address this. I would probable move the filter up the data stream, either into the query, or into the Dataset properties.

But some two other methods are described in this MSDN Community thread: Either creating a fake total row within the group members that contains the =RunningValue(...) function, and set the visibility to only show on the last row; or refer to another page item where you can get just the total of your filtered items.

Upvotes: 8

Related Questions