6 Replies Latest reply on Feb 23, 2016 1:34 PM by Shawn Wallwork

    Calculating Max of date for each customer with the amount associated with same date.

    ChandraSheker A

      Hi Everyone,

      Below is how my data Looks,

       

      My question is, I wanted to see all customers, With Max of the date and Amount associated with max of date.

      ex:      Glass LLC         11/30/15         5075       ( can see in above pic)

                fitness LLC         2/19/13             0

       

      And the Balance column is a Dimension field for me.

       

      Thanks,