Sub Total, Filter

[confused4]

I have problems what to filter first before executing a Sub Total:

I have 6 columns:

I want to have a subtotal per Customer per Brand showing the highest amount of per Customer

Like :
Gas Total 1,450,000
Diesel Total 800,000
Customer D Total 2,250,000
______________________________________________________________________
[TABLE="width: 476"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]BRAND[/TD]
[TD] TotalAmount[/TD]
[TD] Leaked[/TD]
[TD] Plant A[/TD]
[TD]Plant B
[/TD]
[/TR]
[TR]
[TD]Customer D[/TD]
[TD]Diesel[/TD]
[TD] 800,000.00[/TD]
[TD] 400,000.00[/TD]
[TD] 200,000.00[/TD]
[TD] 200,000.00[/TD]
[/TR]
[TR]
[TD]Customer A[/TD]
[TD]Gas[/TD]
[TD] 500,000.00[/TD]
[TD] 100,000.00[/TD]
[TD] 280,000.00[/TD]
[TD] 120,000.00[/TD]
[/TR]
[TR]
[TD]Customer D[/TD]
[TD]LPG[/TD]
[TD] 880,000.00[/TD]
[TD] 400,000.00[/TD]
[TD] 280,000.00[/TD]
[TD] 200,000.00[/TD]
[/TR]
[TR]
[TD]Customer A[/TD]
[TD]Gas[/TD]
[TD] 950,000.00[/TD]
[TD] 380,000.00[/TD]
[TD] 300,000.00[/TD]
[TD] 270,000.00[/TD]
[/TR]
[TR]
[TD]Customer W[/TD]
[TD]Kerosene[/TD]
[TD] 720,000.00[/TD]
[TD] 340,000.00[/TD]
[TD] 200,000.00[/TD]
[TD] 180,000.00[/TD]
[/TR]
</tbody>[/TABLE]



Thanks in advance for helping.