Refer Source:

Reporting Services (SSRS) Part 6 - Grouping in Tables

Applying Grouping to Tables:

- Creating a Parent Group

- Adding Subtotal

- How to Sort with Groups

- Creating Collapsible Sections

- Creating Nested Group

*

[Row Groups]                          [Column Groups] ->Advance mode

*
[Row Groups] ->right click [Add Group] -> [Parent Group]

- Group By [Director Name]
 - Add Group header
 - Add Group footer

note: if you want sum on a field , in that column in a field right click and choose

Looking at "Expression" can see [Sum(field)]
*
Sorting

Design view complete left corner can see "Tablix properties" when right click , but sorting is not done here.

[Row Groups]
[DirectorName] -Properties - Sorted
                            [Details] -Group Properties - Sorting - Add

*
Page Break

[Row Group]
[DirectorName] - Group properties - Page Breaks
                                 Page Breaks
                                 - Page break options:
                                 - Between each instance of a Group
                                    - Also at the start of a Group
                                    - Also at the end  of a Group

*Collapsing

Remove Page Break - to show this

[Details]
   Categories
 Visibility
      Hidden [True]
      ToggleItem [DirectorName1]

*
[Row Groups]                 [Column Groups] - right click - Advanced Mode
                                                              (note:show more options now)

[(DirectorName)]
[Static] - True , ToggleItem[Director1]
[Details]
[Static]

*Nested Groups

[DirectorName] -> Choose [ParentGroup] -> [CountryName]

 [CountryName] -> Group Properties - Page Break