Issue with Total calculation on a pivot table

[pdumas]

Hi,

My data are :

load * Inline
[Group,ID,Value
A,ID1,12
A,ID1,15
A,ID2,10
B,ID1,3
B,ID3,14];

On a pivot table, I count distinct ID by Group

I would like to get a total IDs of 4 : 2 IDs per group, and QlikView gives a total of 3 because ID1 participates to group A and B.

How can I get the total I expect?

The example is attached

Thanks

Pierre.

[#2 · Accepted solution]

Looks like you want it distinct by Group and ID together. See attached.

Tom