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