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

and then use expression like this

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

By simplemsexchange Posted in SSRS

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s