pivot table cash flow

Question

I have a table with my cash flow:

Cash flow table:

Where: Data → Transaction date (Brazilian time DD-MM-YY) Type → SAIDA = Cash outflow and ENTRADA=cash inflow

What I need is to know each day balance value like that:

Expected result:

To do that I'd have to grab the last occurrence of each day buy I'm not managing to that.

I've already tried to use pivot table but unsuccessfully. As you can see below, using pivot table I receive more than one date per balance.

Pivot table set up:

Answer 1

1. Add a helper index column counting up.
2. Sort your list on the index column from high to low, so that the most recent transaction is on the top
3. Select your full table and use the remove duplicates option and only select your date column.

This will remove all duplicate dates and keeps rows with the last transaction of every date.