Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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.
Oh, I see
hmmm thank you sunny given the solution. yours also working fine thanks both of you
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])
Thank you, Sunny)) I'll keep it in mind.