listbox count

[soniasweety]

Hi all,

Andrey Krylov

Tresesco B

i want to show distinct count  in textobjects  both red and green distinct count only

and below that listboxes

1 listbox should show only red values(other values should be hidden)

2. second list box only green values(other values should hidden)

these two listboxes should show the respective textbox values.

[andrey_krylov]

Oh, I see

[soniasweety]

hmmm    thank you sunny given the solution.   yours also working fine thanks both of you

[sunny_talwar]

andrey.krylov‌ You can simplify it using this

=Aggr(Only({<[Match Rate] = {">0.97<1.03"}>} [Business Area Code]), [Business Area Code])

and this

=Aggr(Only({<[Match Rate] = {"<=0.97>=1.03"}>} [Business Area Code]), [Business Area Code])

[andrey_krylov]

Thank you, Sunny)) I'll keep it in mind.