Identify last 'Balance' value in Line Chart for a given day

[#1]

Hello,

I want to achieve the following scenario in Line Chart (and not in script) -

Scenario - In a given date of a month there can be more than one transaction. For example, a bank account may undergo several debits and single credit on a given date. This changes the Balance for that account, multiple times, for that day. How will then I identify the last balance value for that date, i.e,  'last balance amount'??

Please find the attached .xls file having sample data set ---> I need 44,982.98 as my last Balance value on 01/01/2014 to be shown as data point in Line Chart (using some expression)

Thanks,

Abhishek

[#2 · Accepted solution]

Never mind...I just found it in F1 --> Chart aggregate functions.

=FirstSortedValue(Balance,-[Serial No],1)

Thanks!