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.

[Anonymous]

you use your Expression of your Background Color in Dimension and Change it accordingly

e.g. for the green values

=IF(Num([Match Rate],'#,##0.00%')>'97.00%' and Num([Match Rate],'#,##0.00%')<'103.00%',[Business Area Code])

for the red values

=IF(Num([Match Rate],'#,##0.00%'<'97.00%' or Num([Match Rate],'#,##0.00%'>'103.00%',[Business Area Code])

you may Name your listbox e.g. BAC in range or out of range

[soniasweety]

no. user want in listbox only..

im able to get the distinct count but    that only count show in listbox how to hide other values?

[andrey_krylov]

Hi Sony. See attached

[soniasweety]

Hi andrey.krylov   i got distinct count in text objects.  but that same count values should show in list box

how can i do that?

means-  in red  text object the count is 2--  so one listbox it should show that 2 values

same for green also.

[sunny_talwar]

List box? You will be making selection to these single value count expressions? What do you want to see when you select a count expression? I am not sure I understand why you need a list box? Can you elaborate?

[soniasweety]

Hi sunny,

1.user want to see the  count of  red colur and green coulr values in text object

2. that same values should  display in listbox or  strigttable  with  single dimension.

now red count is 2..  user want to see which are that two codes

[sunny_talwar]

May be try these

=Aggr(Sum(If([Match Rate] > 0.97 and [Match Rate] < 1.03, 1, 0)), [Business Area Code])

=Aggr(Sum(If([Match Rate] > 0.97 and [Match Rate] < 1.03, 0, 1)), [Business Area Code])

[soniasweety]

not count sunny

that values.   which are the codes are red which are the codes are green user want to see.

[sunny_talwar]

So, what exactly would you see in the list box? 2G00 repeating twice?