Map multiple rows single existing row

[Annapurna1]

Hi,

I have Multiple branches in city ahmedabad but i want to show count of all the branches with only one branchname1 as shown below.

I want to map rows of BranchName with my existing row BranchName1. Where TW Count and TW Value are measures.

This is Qlik output.

Sr No

Zone

State

City

BranchName

BranchName1

Branch ops Region

RM Name

Branch Ops

Manpower Count

Single Manpower

TW Count

TW Value in CR

3

West

Gujarat

Ahmedabad

Ahmedabad- **bleep**al Varsha

Ahmedabad- Navrangpura

WEST 2

Pragnesh Patel

Yes

6

Multiple

0

0

-

West

Gujarat

Ahmedabad

Ahmedabad-Ambavadi

Ahmedabad- Navrangpura

WEST 2

Pragnesh Patel

-

6

Multiple

0

0

-

West

Gujarat

Ahmedabad

Ahmedabad-Ambavadi-2

Ahmedabad- Navrangpura

WEST 2

Pragnesh Patel

-

6

Multiple

105694

229.7152379

-

West

Gujarat

Ahmedabad

Ahmedabad-C.G Road

Ahmedabad- Navrangpura

WEST 2

Pragnesh Patel

-

6

Multiple

0

0

-

West

Gujarat

Ahmedabad

Ahmedabad-C.G Road-160

Ahmedabad- Navrangpura

WEST 2

Pragnesh Patel

-

6

Multiple

163981

1.469091526

But my expected output is, Both the branch names should be mapped and the count of TW and TW value should also be add with each other

Sr No	Zone	State	City	BranchName1	Branch ops Region	RM Name	Branch Ops	Manpower Count	Single Manpower	TW Count	TW Value in CR
3	West	Gujarat	Ahmedabad	Ahmedabad- Navrangpura	WEST 2	Pragnesh Patel	Yes	6	Multiple	2,69,675	231.17

Help me out