20 Replies Latest reply: Jul 18, 2016 5:24 AM by Marcus Sommer RSS

    How to pick latest moment on a day and lose rest of records?

    Hans de Vries

      I have a table with multiple accountnumbers. Here is only one, of many more. As you can see, there can be several mutations in the Cumulative amount per day. What I want is a table that lists just one day at a time, with the cumulative amount that was present at the latest time of that day. The rest can be discarded.

       

      Any help would be much appreciated!