Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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