Could you please let me know if I can sort on a field which uses table calculation (TOTAL)? I am unable to see the sort icon on the column label.
I have four metrics on my dashboard and one of them uses table calculation. Due to this field, I am unable to sort on any of the fields present on the dashboard.
I guess if you convert table level calculation to "Discrete", you will have sorting option enabled.
please share your workbook to understand context of your problem.