Hi
Please help me with the first sorted value function?
Below is the input table and set analysis used in the dashboard.
| Company | Groups | Amount |
| ZABC | IT | 0 |
| DSC | Accounting | 0 |
| WAT | IT | 0 |
| CI | Accounting | 0 |
| CC | IT | 0 |
| SES | Accounting | 0 |
| WS | Accounting | 0 |
| SW | IT | 0 |
| PAT | IT | 0 |
Expression : FirstSortedValue({<Company=>}Distinct Company,Aggr(Sum({<Company=,Groups=>}Amount)+Sum({1}0),Company))
Result: ZABC
Is there any way to get the result based on alphabetical order?
I am expecting CC in the result.
Thank you,
Binu
