I am trying to sort a column in my table:
Table - โCustomersโ
Column - โCustomer_Nameโ
All i want is the column โCustomer_Nameโ to be in ascending order by name.
I have tried using SORT().
I tried ORDERBY
I tried putting the formulas in โValid_IFโ and โFormulaโ
I am at a loss. Any help would be greatly appreciated.
Thanks
Solved! Go to Solution.
WORKED PERFECTLY. Thanks so much Steve!
Row sorting in a table view is controlled exclusively by the column sort order indicated in the view configuration itself:
Sorry. The table โCustomersโ is referenced by another table โTicket logโ. Inside the ticket lo - i have the column โcustomer Nameโ - which comes from that table.
So basically it is a referenced column that i need sorted. I cannot sort it how you showed. It is not a table VIEW. i use it in a form (dropdown menu)
Ah, sorry I misinterpreted your problem. Have you seen this?
Thanks. But i dont want to filter out anything. I am sorry i am not explaining this very well.
I have two tables - โCustomersโ and โTicket Logโ.
Customers table has โCustomer_Codeโ - the key and โCustomer_Nameโ - the Label
Ticket Log table has โCustomer keyโ - reference to โCustomersโ table and โCustomerโ - [Customer key[.[customer_name].
I need the Column โCustomerโ from the Ticket Log Table - to list all those reference names customers in ascending order.
The doc I referenced above is relevant. You should read it.
Set the Valid If expression for the Customer key column of the Ticket Log table to:
ORDERBY(Customers[Customer_Code], [Customer_Name], FALSE)
WORKED PERFECTLY. Thanks so much Steve!
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |