4 Replies Latest reply: Mar 7, 2013 11:54 AM by Fabio Marino

# Wrong total in pivot table

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
• ###### Re: Wrong total in pivot table

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?

• ###### Re: Wrong total in pivot table

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

• ###### Re: Wrong total in pivot table

See attached qvw

• ###### Re: Wrong total in pivot table

thanks