2 Replies Latest reply on Mar 28, 2016 11:40 PM by Eshwar Prasad

    Max date row in the Grid view.

    Eshwar Prasad

      Hi Team,

       

      I have a requirement as below.

       

      Need to display the customer latest order date and category in the grid view. in the below screen shot, customer Ryan Mckenzie has 3 records with different order date in different categories. But i need to show most recent order date and catogery if customer is having more than one category based by taking max order date.

       

      i tried with  below calculation but it is not giving proper result.

       

      max(orderdate)=windowsmax(max(orderdate)), filtered with true.