Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a datatable that consists of 3 separate areas and corresponding dates. I need to show the top 10 comments for each area in 10 separate textboxes.
My Datatable look like :
The 10 texboxes should only be populated when the user has selected an Area from ListBox.
So, Im guessing that the set analaysis for Texbox 1 should resemble something like :
Only when a Distinct Area has been selected show Comment where the Order_Number = 1
TexBox 2 : Only when a Distinct Area has been selected show Comment where the Order_Number = 2
and so on for 10 textboxes
Hope someone can advise?
Thanks,
Tom
For textbox 1:
=if(GetSelectedCount(Area)=1, only({<order_number={1}>}Comment))
For textbox 2:
=if(GetSelectedCount(Area)=1, only({<order_number={2}>}Comment))
and etc.
For textbox 1:
=if(GetSelectedCount(Area)=1, only({<order_number={1}>}Comment))
For textbox 2:
=if(GetSelectedCount(Area)=1, only({<order_number={2}>}Comment))
and etc.
perfect thank you!