How to filter table on a calculated balance sheet using a Max date?

I have transformed my data source into income statement (movement from previous quarter starting each FY at zero[July in my case]) and balance sheet and cash flow being the cumulative balance as per ...