Hi guys,
I am a little stuck in bringing the next String (WO Type) when it meets a condition (WO Type = EN1, EN2, EN3, EN4) see screenshot below.
I want to bring the next record when a certain condition is met. As this is not an aggregation therefore, Lookup function doesnt seems to work here.
I have also tried If function but cannot get to a solution.
Would appreciate your help.
Thanks in advance.
Hold CTRL and drag the Next Type pill up to the filters pane, then filter it to only show values of 1:
See attached.
if my answers have helped you to find a solution, would you be so kind as to mark them as helpful and/or the "correct answer"? Marking a correct answer will allow us to close the thread and, more importantly, will cause that response to bubble to the top, making it easier for others to find answers to similar questions in the future. Thanks!
