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 |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |