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.

       

      Thanks