Adding value to Max Field-Pls help,trying from very long

[KhushiRaina]

Hi friends,
In my report there is grouping by
city,location and branches showing totals for 'total value' field from database each group wise.
I need to get max of Sum('total value') in branches for a location as there are same branches with different total value and then also get Sum('total value') for a branch='Unknown', then add this unknown 'total value' to the Sum(total value) of branch having max total value.
At present its displayed as :-
city - India [city grouping]
location - Delhi [location grouping]
Branch Total Value
B1 300 [ Branch Grouping
B2 200 [ Sum of Total value Branch Wise
Unknown 100
Total 600
.
.
.
The Detail section is suppressed.
So the total value 100 should get added to branch B1 total value 300 making the total value to 400 and suppress the unknown branch,so the total still remains 600.
So it should display as :-
city - India
location - Delhi
Branch Total Value
B1 400
B2 200
Total 600
.
.
.
As of now thru a formula i am getting the max total value and by comparing each total value to this i get branch name and then i am adding the unknown total to this max branch total.Is there any other solution.Hope to receive some solution.