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 ______________________________________________________________________ Customer BRAND TotalAmount Leaked Plant A Plant B Customer D Diesel 800,000.00 400,000.00 200,000.00 200,000.00 Customer A Gas 500,000.00 100,000.00 280,000.00 120,000.00 Customer D LPG 880,000.00 400,000.00 280,000.00 200,000.00 Customer A Gas 950,000.00 380,000.00 300,000.00 270,000.00 Customer W Kerosene 720,000.00 340,000.00 200,000.00 180,000.00 Thanks in advance for helping.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Sub Total, Filter

Thread starter confused4
Start date Sep 5, 2015
Tags

filter sub total

confused4

New Member

Sep 5, 2015

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
______________________________________________________________________

Customer	BRAND	TotalAmount	Leaked	Plant A	Plant B
Customer D	Diesel	800,000.00	400,000.00	200,000.00	200,000.00
Customer A	Gas	500,000.00	100,000.00	280,000.00	120,000.00
Customer D	LPG	880,000.00	400,000.00	280,000.00	200,000.00
Customer A	Gas	950,000.00	380,000.00	300,000.00	270,000.00
Customer W	Kerosene	720,000.00	340,000.00	200,000.00	180,000.00