Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table consisting of category and dollar volume that I'd like to sort by dollar volume (desc), but would like to see the category of 'Other' to always be listed last. Is that possible to do?
Try an expression like this maybe?
if(Category = 'Other', 9999, rank(dollar volumn))
Try an expression like this maybe?
if(Category = 'Other', 9999, rank(dollar volumn))
That worked, thanks so much!!!