Dear All,
| Branch | Customer | Target | Achieved |
| | | | |
| Branch 1 | Customer 1 | 100 | 50 |
| Branch 1 | Customer 2 | 100 | 20 |
| Branch 1 | Customer 3 | 0 | 20 |
| Branch 1 | Customer 4 | 0 | 40 |
| Branch 2 | Customer 1 | 40 | 20 |
| Branch 2 | Customer 5 | 0 | 50 |
A above is my transaction table
Output is
| Branch | Target | Achieved | Without Target Achieved |
| | | | |
| Branch 1 | 200 | 130 | 60 |
| Branch 2 | 40 | 70 | 50 |
If target is 0 for the customer then in
Without target achieved column gets calculated. Is it possible????
