I need to sort and filter rows at the same time. I have 2 items to filter out:
[Milestone] โ13 Closedโ
[Milestone] "14 Funded
The expression below works fine, I just need to add the 2nd item and dont know how
Current expression
ORDERBY(SELECT(customers[ID],[Milestone]<>โ13 Closedโ),[Customer],FALSE)
Please help
Thanks
Hi @teamMedina
Check out AND()
Yes, what @Lynn said โฆ you can use AND() to combine filtering criteria in the SELECT() function
In the SELECT(). It would look like this:
ORDERBY(SELECT(customers[ID],
AND([Milestone]<>โ13 Closedโ, [Milestone]<>โ14 Fundedโ)),
[Customer],FALSE)
Naiiiiissssโฆ it worked. Thank you Lynn and John for taking the time โฆ Enjoy the holiday weekend
Cheers
TM
Where do I write the AND?
ORDERBY(SELECT(customers[ID],[Milestone]<>โ13 Closedโ),[Customer],FALSE)
@teamMedina
Good work!
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |