Can someone please help how I can sort by highest number? I would like to sort the vendor name by 2023 Total amount.
Best answer by Benoit 27 October 2023, 17:12
Unfortunately the sorting feature can not be used on aggregators.
It works only on dimension properties or metric values.
A good workaround is:
Hope this helps.
Thanks for suggesting workaround option!
I created two properties - 1) to get 2023 total amount (like a stage) and 2) for final output to Rank based on #1.
Can you please help on the Rank formula? I tried but seems the result doesn’t look right.
What is the current formula you have?
You should be able to use the rank function
Rank(Vendor_OP.’2023 Total (A+F)’) should work
If zeros are listed as third position, it means maybe you have 2 negative values.
To verify, maybe you could go to your metric and use the sorting to see if it renders correctly?
Ah, formula is simpler than expected. Thank you!
Don't be shy - let the Community help.
Already have an account? Login
Single Sign-On Need help?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.