3 Replies Latest reply on Jul 1, 2015 1:38 PM by Joe Oppelt

    Sorting on Calculated Fields

    Ijaz Ahamed Meeran Abdul Jabbar

      Hey All,


      PFA the worksheet attached. I have a similar kind of problem and I have recreated it using superstore data. I wanted to find the sales of the city when the profit is maximum. I have done that using window_Max calculated field and I am now able to achieve it.


      After doing that, I am not able to sort the sales column. Can anybody help me how to sort it based on the sales. I am able to sort by city. But not able to sort by sales.


      Any help would be appreciated.