I have a table in excel. I want to create a pivot table where:
- Take the final value of
capital left
on that day if there are more than one trade on the same day.
- In my example below, since there are 2 trade on 2019-07-22, the value in pivot table should be $4586.69 instead of $4617.80 or $9204.48.
- Not sure why the value of
capital left
for 2019-07-16 is $9145.96 instead of $4632.55
- There is no $59494.22 at the first row of the pivot table (not sure why it appear).
I attached a screenshot below in case you don't understand what I mean. I'm new to pivot table and hope to get some advise, thanks!