Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have attached one QVW, as you can see the partial sum of Center Name is not correct in North-A, it should be 4 instead of 5.
As you can see the Data, Center AAA, BBB, DDD shared the same LeadID: 1,2,3
Center CCC uses its own LeadID 4,5
What I want to do is if the Center under BJ that is AAA, BBB, DDD, the Leads should be divided by 3.
So I use this expression: If(City='BJ', count(DISTINCT LeadID)/3, count(DISTINCT LeadID))
However, the sum partial is not correct, could you help me out?
Thanks.
Hi,
modify your expression with sum(aggr(yourExpression,dimension))
try like
sum(AGGR(If(City='BJ', count(DISTINCT LeadID)/3, count(DISTINCT LeadID)),Region,RegionDash,CenterName))
Regards
Hi,
modify your expression with sum(aggr(yourExpression,dimension))
try like
sum(AGGR(If(City='BJ', count(DISTINCT LeadID)/3, count(DISTINCT LeadID)),Region,RegionDash,CenterName))
Regards