开发者

SSRS: Summing Group totals

开发者 https://www.devze.com 2023-02-08 02:53 出处:网络
I have 3 groups. in group 3 I have the following calculation: =IIF(SUM(Fields!ViolationPoints.Value * Fields!TimeWeight.Value) > 30, 30, SUM(Fields!ViolationPoints.Value * Fields!TimeWeight.Value))

I have 3 groups. in group 3 I have the following calculation: =IIF(SUM(Fields!ViolationPoints.Value * Fields!TimeWeight.Value) > 30, 30, SUM(Fields!ViolationPoints.Value * Fields!TimeWeight.Value))

How can I then sum these totals in a group 1 field. Basically I get about 2 or 3 records in gorup 3 and 开发者_运维技巧I need to show the sum of that in gorup 1.

Thanks!


We need more information; are you using a Table to display your groups or are these simply calculations that you want to perform outside of the Tables?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号