Forum Discussion
Advanced Filters and Filtering
I have been successful in creating individual tables with the below criteria, but It has been requested by my boss to combine and only show the results when the criteria have been met. Any suggestio...
Anonymous i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.
you can write a swithc with following criteria
SWITCH(TRUE().
OA >= 83 && MAT < 48,"Y",
OA >= 70 && OA < 83 && MAT > 78,"Y",
"N")
Feel free to add the required conditions to create the filter and then filter results based on it.
Anonymous i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.
you can write a swithc with following criteria
SWITCH(TRUE().
OA >= 83 && MAT < 48,"Y",
OA >= 70 && OA < 83 && MAT > 78,"Y",
"N")
Feel free to add the required conditions to create the filter and then filter results based on it.