11 Replies Latest reply on Dec 9, 2017 10:16 AM by Angela Tate

    Auto Sorting on a Calculated Field

    Brandon Whitman

      I'm wondering if there is a way to sort on a calculated measure the same way you can sort on a Dimension. I have a Measure (Sales) that I converted into a "% Difference From" from Quarter to Quarter. I can manually sort the % change descending by clicking the Descending button, but I would like this order to stay consistent when I change other filters. So if I display the % change in Sales for one product, then switch to another, the descending order doesn't keep up and I have to manuall click descend again. Is there a way to set this so it does it automatically?