Count distinct on multiple selections

[hari8088]

Hi Experts,

Below is my table

LOAD * INLINE [

    id, product

    1, A

    2, A

    3, A

    4, A

    1, A

    2, A

    3, B

    4, B

    5, B

    6, B

    7, B

    5, B

    7, C

    8, C

    9, C

    10, C

    8, C

    9, C

];

The above table contains duplicate id's by product.

when i wrote expression count of distinct id in text object.

i have a listbox called product when i made selection on product A it is giving the count 4 which is true.

here if i made selections on A and B at a time i have to get the count 9 which means for A is having the distinct value of 1,2,3,4

and for B having the value of distinct 3,4,5,6,7

my total count would be 9 but i am getting the count is 7 when i wrote count of distinct id.

[#2]

Hi Hari,

Have a look at the attached application.Hope it helps!