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.
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
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.
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?
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
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])