如何将总计添加到SSRS中的每个组中

Question

我需要为SSRS中的一个行组中的每个分组提供一个总计。当前，在行组的末尾添加一个总计。

因此，如果我有以下数据：

TeamName    BusinessSegment  PaymentPeriod  BusinessArea      ProductType        PolicyCount201501    Premium201501   
---------------------------  -------------  ----------------  ----------------   ------------------   --------------- 
Office      Non-property     Monthly        Commercial Lines  Sectional Title    0.00                 0.00            
Office1     Non-property     Annual         Commercial Lines  C&I Generic (Web   1.00                 24025.00        
Office1     Non-property     Annual         Commercial Lines  Property Protect   1.00                 24025.00       
Office1     Non-property     Monthly        Commercial Lines  BizzInsure         1.00                 24025.00      
Office1     Non-property     Monthly        Commercial Lines  Sectional Title    1.00                 24025.00       
Office2     Non-property     Annual         Commercial Lines  Property Protect   1.00                 24025.00        
Office2     Non-property     Annual         Commercial Lines  Sectional Title    1.00                 24025.00        
Office2     Non-property     Annual         Commercial Lines  Sectional Title    1.00                 24025.00        
Office2     Non-property     Monthly        Commercial Lines  M&F Commercial B   1.00                 24025.00        
Office2     Non-property     Monthly        Commercial Lines  Sectional Title    1.00                 24025.00  

我希望输出是这样的：

Team Name       Business Segment    Payment Period  Business Area       Product Type    Policy Count 201501     Premium 201501
Office          Non-property        Monthly         Commercial Lines    Sectional Title 0.00                    0.00
                                                    Total                               0.00                    0.00
                                    Monthly Total                                       0.00                    0.00
                Non-property Total                                                      0.00                    0.00
Office Total                                                                            0.00                    0.00
Office1         Non-property        Annual          Commercial Lines    Something1      1.00                    1.00
Office1         Non-property        Annual          Commercial Lines    Something2      1.00                    1.00
                                                    Total                               2.00                    2.00
                                    Annual Total                                        2.00                    2.00
Office1         Non-property        Monthly         Commercial Lines    Something1      0.00                    1.00
Office1         Non-property        Monthly         Commercial Lines    Something2      1.00                    1.00
                                                    Total                               1.00                    2.00
                                    Monthly Total                                       1.00                    2.00
                Non-property Total                                                      3.00                    4.00
Office1 Total                                                                           3.00                    4.00
Office2         Non-property        Annual          Commercial Lines    Something1      0.00                    1.00
Office2         Non-property        Annual          Commercial Lines    Something2      1.00                    1.00
                                                    Total                               1.00                    2.00
                                    Annual Total                                        1.00                    2.00
Office2         Non-property        Monthly         Commercial Lines    Something1      2.00                    1.00
Office2         Non-property        Monthly         Commercial Lines    Something2      1.00                    1.00
                                                    Total                               3.00                    2.00
                                    Monthly Total                                       3.00                    2.00
                Non-property Total                                                      4.00                    4.00
Office2 Total                                                                           4.00                    4.00
Grand Total                                                                             7.00                    8.00

注意，PaymentPeriod是按Monthly和Annually分组的，在Monthly之后有一个总计，在Annually之后有一个总计。当前，呈现以下内容(请注意每个Annual分组结束时的单个PaymentPeriod总数：

Team Name       Business Segment    Payment Period  Business Area       Product Type    Policy Count 201501     Premium 201501
Office          Non-property        Monthly         Commercial Lines    Sectional Title 0.00                    0.00
                                                    Total                               0.00                    0.00
                                    Monthly Total                                       0.00                    0.00
                Non-property Total                                                      0.00                    0.00
Office Total                                                                            0.00                    0.00
Office1         Non-property        Annual          Commercial Lines    Something1      1.00                    1.00
Office1         Non-property        Annual          Commercial Lines    Something2      1.00                    1.00
                                                    Total                               2.00                    2.00
Office1         Non-property        Monthly         Commercial Lines    Something1      0.00                    1.00
Office1         Non-property        Monthly         Commercial Lines    Something2      1.00                    1.00
                                                    Total                               1.00                    2.00
                                    Annual Total                                        3.00                    4.00
                Non-property Total                                                      3.00                    4.00
Office1 Total                                                                           3.00                    4.00
Office2         Non-property        Annual          Commercial Lines    Something1      0.00                    1.00
Office2         Non-property        Annual          Commercial Lines    Something2      1.00                    1.00
                                                    Total                               1.00                    2.00
Office2         Non-property        Monthly         Commercial Lines    Something1      2.00                    1.00
Office2         Non-property        Monthly         Commercial Lines    Something2      1.00                    1.00
                                                    Total                               3.00                    2.00
                                    Annual Total                                        4.00                    4.00
                Non-property Total                                                      4.00                    4.00
Office2 Total                                                                           4.00                    4.00
Grand Total                                                                             7.00                    8.00

我怎样才能做到这一点？

Answer 1

将另一个子组添加到Payment Period组中，并将总计添加到第二个组中。从显示的第一个组中删除列(不要删除第一个组)。

​

​

输出：

​

​