I am trying to figure out how to properly write the dependent dropdown expression using the “ORDERBY” expression to sort the resulting responses alphabetically.
Dependent drop down expression:
IN( [_THIS], SELECT(Inventory Items[Category], [_THISROW].[Factory] = [Category]))
Attempted to add orderby:
ORDERBY(IN( [_THIS],SELECT(Inventory Items[Category], [_THISROW].[Factory] = [Category]),[category]))
I get the error “ORDERBY has invalid inputs”
I’m pretty sure I wrote the expression wrong but I can’t seem to figure out the correct way. Any suggestions?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |