Individual total by Branch

[#1]

Dear all,

Please see attached Excel and qvw  files.

In qvw file I want Branch1 and Branch2 total according to there individual.

I am doing something wrong that's why it repeated.

Please can you help me guys.

Thanks

Vinay

[#2]

It's done by myself

I was using...

=aggr(sum({<Branch = P(Branch1) >}sales),Group,Branch1,[Branch Name1])

But now I used

(if(Branch=Branch1,sales))

and its working.

Any way thanks for watching forum.

Vinay