2 Replies Latest reply on Apr 5, 2018 4:28 PM by Xiaoxiao Peng

    dynamic sorting for a column in the graph

    Xiaoxiao Peng

      I created a graph comparing two periods. The rows in the graph needs to be sorted based on the values in the second period. The finally graph will involve many filters, is there anyway you can make the sorting dynamic without manually dragging?

      I attached the workbook based on mock-up data.


      Below is the graph.





      It needs to look like this.


      Many thanks!