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
______________________________________________________________________
<tbody>
</tbody>
Thanks in advance for helping.
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 |
<tbody>
</tbody>
Thanks in advance for helping.