Finding max of an aggregate function in tableau

Question

I have a question w.r.t to finding max or min of an aggregate function in tableau.

Tableau report is a biller details report where there are multiple billers and for each biller, there are multiple transactions. Each transaction has opening balance, closing balance, debitor, creditor, transaction date, time etc. Requirement is to find the opening and closing balance for each biller. Formula to calculate Opening Balance = Sum(Closing Balance) - sum(transaction amount) - sum(service fee)

The problem is when user specifies a date range, report should show the closing balance as of the end date of that date range. Report is showing the cumulative sum of opening balances of all the transactions in the date range, but I only want the closing balance of the last transaction as per the date range. If I put MAX(Closing Balance), tableau says this is an aggregate function and can't apply max to it.

Any ideas on how to resolve this ?

Answer 1

等待大神答复