Total of Sub Total in Grand Total raw

What should I set the Expression for red marked text box ? Manually: Red Box value = Subtotal of Box1 Keep_Level+ Subtotal of Box2 Keep_Level

If I set Expression to : =Sum(Fields!Keep_Level.Value), the result is comming = 80

 

Solution by MS Forum Member I got which works:

create a new dataset with distinct sum like this

SELECT     SUM(DISTINCT Amount) AS total
FROM         GroupingProblem
GROUP BY NAME

and then use expression like this

=Sum(Fields!total.Value, "DataSet2")

Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s