The Pivot table Partial sum issue

Tue, 22 Sep 2015 02:32:45 GMT

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.

Re: The Pivot table Partial sum issue

PrashantSangle — Tue, 22 Sep 2015 03:17:48 GMT

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