1 of 1 people found this helpful
Thank you, Lei Chen.
Upon trying to recreate what you have done, I have noticed that the sub-category had a manual sort. I need this solution to be fully dynamic unfortunately.
Any other ideas?
I previously thought that desc sort would work dynamically, but it turned out not.
When clicked on asc/desc sort of an aggregated measure (without table calculation), the sort is dynamic.
When clicked on asc/desc sort of an aggregated measure (with table calculation), the sort becomes manual
Sorry that I haven't got any idea currently.
2 of 2 people found this helpful
Please try the attached, I've done the same as Lei where I created the absolute difference as a calculated field, then I used rank (or I guess you can use rank unique) with this field.
Thanks Mavis, this is perfect!