Here is my 'Valid if' formula to limit my list of names in the dropdown (dependent on two variables)
but the list are not alphabetically arranged,
Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category]))
How Can I Sort them alphabetically
Tried ORDERBY(Stock Inventory[Item Name], [Item Name)
Help!
Solved! Go to Solution.
sort(Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category])),false)
SORT()
ORDERBY() is only for key values.
sort(Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category])),false)
Thank you!!!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |