Grouping in a report within a Footer

[Sonu]

Dear All,




I need help in developing a small requirement in a report. Please refer to the attachment so that you can relate to the fields I will be talking about:


The report currently displays data by grouping with District -> Location -> Dept Description -> Expr2 and their respective group counts on the right.


Sample data might be like:


District_1 <DistrictTotalHere>
Location_0001 <LocationTotalHere>
Dept_1 5
F 2
T 3
Dept_2 30
F 10
T 20
..
..
..


Please note that the Expr2 values (i.e. as per above example : F and T) will always remain constant, only the other group values will change.


Now, I want to add a Location Footer which should display a total at District -> Location -> Expr2 level. That means the above output should look like below:


District_1 <DistrictTotalHere>
Location_0001 <LocationTotalHere>
Dept_1 5
F 2
T 3
Dept_2 30
F 10
T 20


Total F 12
T 23


Is this possible to implement using the Group & Sort options or can someone suggest an approach? If any additional information is required, I can surely provide it.


Thank You.

[Sonu]

Sorry about the sample data, I used tabs to show but after posting the thread they were lost. I will add an attachment to display the sample data.

[Sonu]

Sample data - Current Report output v/s expected report output

[Sonu]

Sample data - Current Report output v/s expected report output

Hello guys, could someone please help in this regard?

Thank you.