"Hi, I have a table called Libro de Clases, which is filled in the columns Profesora, Nivel and Jornada using the formula LOOKUP(USEREMAIL(),Profesoras, EMail,Nombre).
I need is to be able to select the list of students that meet the three criteria: Teacher, Level and Day, either through an enum list or another alternative that you can suggest.
Something like this, but with the referenced data as I show early.
Please keep the language simple, as I am quite new to this program
Let's assume the "Pick a continent" would be an EnumList column. Then the dependent dropdown for the "Pick a country" needs to be..
SELECT(Documents[Country],IN([Continent],[_THISROW].[Pick a continent]))
Thanks!
What I need is that in the second pic, below Jornada, show the enumlist of students dependant of theese filters: Profesora, Niveles y Jornada.
The real data are the first 2 pics, could you give me a hand?
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |