Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
If you want to sort alphabetically and take first value of Company then may be you can use Minstring().
Thanks,
Ashutosh