0 Replies Latest reply: Sep 19, 2017 11:15 AM by Sathwik Vangari RSS

    Dynamic sorting on alternate dimensions

    Sathwik Vangari

      Hello. I am mapping current and previous year sales (2 measures) data on a bar chart (2 dimensions - salesperson and sales territory). I want the sorting of data to happen on descending value of sales bought by salespersons. So I set the sorting of salespersons to 'by expression' and selected 'current year sales' measure. This sorts well. However, when I use the alternate measure, i.e. Last year sales, the order is all scrambled because it still sorts by 'current year sales'. Is there a way to dynamically sort based on the measure being selected?