how to remove unwanted row from the table

[kunkumnaveen]

Hello All,

i was able to achieve my requirement partial ,i got struck at one point ,  i want my list box should reflect only on one column,and based up on that column the other column values has to display , i mean this is my table when no selection had made in the list box

to achieve this requirement for each column expression i added supcat= except column 3  ( which mean selection made on the listbox will not reflect those column except 3rd column expression )

expressions i wrote for each column

current self eval: FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

auditor current :FirstSortedValue(distinct {<ROLE={'EVAL'},MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

previous self eval: FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW,2)

previous current :FirstSortedValue(distinct {<ROLE={'EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW,2)

then i got what i am looking

but the problem is Arvind Timber supplier whose Auditor current score is 83 which come under B+ i dont  want that  entire  row to be displayed when i select rating A

[kunkumnaveen]

that as to be dynamic , i mean we dont known which value from SUPCAT the end user gonna select

[kunkumnaveen]

Hello ,

Have u find my attachment  ,any help or suggestion from ur end plz

[sunny_talwar]

I will look at the attachment as soon as I reach work. Got busy with getting ready.

Best,

Sunny

[kunkumnaveen]

great thanks for your help and efforts

[Clever_Anjos · Accepted solution]

Change all your expressions (excepct the second one) to something like this

if(Column(2)>0,FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW))

[kunkumnaveen]

Perfect solution ,thanks for your help