5 Replies Latest reply on Apr 4, 2016 1:06 PM by Sever Mesca

    Sorting

    dinesh reddy

      hi ,

      can any one help on this

       

      maximum city name for  a particular state that means for California i am having having so many cities, i need maximum city  of sales for that California.

       

      window_max(sum(sales) is working and i want to display only the actual maximum city not all cities with same maximum value for a particular state.

       

      i want to display only Washington state and  Seattle city

      Sort2.PNG

       

      sort 1.PNG