Wrong total in pivot table

[#1]

I have an pivot table with this value. In the column "if sum" i want to display sumA if is >=1 or sumB if is <=0.

When i collapse the dimension Agent or Customer the sub total is wrong. It do the total of the total of sum a or sum b and not the total of the colum "if sum"

how can i do?

AGENT	customer	SUM(A)	SUM(B)	if sum
Agent1	customerA	0	7	7
Agent1	customeG	0	10	10
Agent1	customeL	9	10	9
Agent1	customeR	5	10	5
Agent2	customeB	5	10	5
Agent2	customeF	5	10	5
Totale		24	57	41

[CELAMBARASAN]

Can you tell me the data input? data displayed in the pivot without collapse?then after collapse?

On observing your table is it returns 14 for Agent1 on collapsing Agent1?

[#3]

the value for total are 41 with collapse and 24 when i see the total for the uncollapse dimension

such as 14 agent1 and 10 agent2.

i would optain 31 for agent1 (14 from sum1 and 17 from sum b) and 10 for agent2

now with the expression if(sum A >=, sum(A), sum (b)) i return me a wrong result if i uncollapse the dimension

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#5]

thanks