Hi All,
I have a table like the following
Company Name | Region | Dealer | ab | non - ab | Unsent | Not Picked Up | Picked Up | Accepted | Total |
A | ASIA | John | 16 | 0 | 0 | 6 | 7 | 3 | 16 |
B | ASIA | Mike | 10 | 0 | 0 | 4 | 5 | 1 | 10 |
C | ASIA | Daniel | 2 | 0 | 0 | 1 | 1 | 0 | 2 |
D | ASIA | Eric | 4 | 0 | 0 | 0 | 1 (Dealer 1) | 3 | 4 |
E | ASIA | Jeremy | 2 | 0 | 0 | 0 | 2 | 0 | 2 |
F | ASIA | Linda | 3 | 0 | 0 | 1 | 2 | 0 | 3 |
G | ASIA | Jin | 0 | 2 | 0 | 0 | 0 | 0 | 2 |
H | ASIA | Ronald | 2 | 0 | 0 | 0 | 2 | 0 | 2 |
I | ASIA | Shiva | 17 | 0 | 0 | 1 | 15 (Dealer 2) | 1 | 17 |
J | ASIA | Kenneth | 4 | 0 | 0 | 0 | 3 | 1 | 4 |
And I want it to look like:
aw | status | Total |
Company Name | Region | Dealer | ab | non - ab | Unsent | Not Picked Up | Picked Up | Accepted |
A | ASIA | John | 16 | 0 | 0 | 6 | 7 | 3 | 16 |
B | ASIA | Mike | 10 | 0 | 0 | 4 | 5 | 1 | 10 |
C | ASIA | Daniel | 2 | 0 | 0 | 1 | 1 | 0 | 2 |
D | ASIA | Eric | 4 | 0 | 0 | 0 | 1 (Dealer1) | 3 | 4 |
E | ASIA | Jeremy | 2 | 0 | 0 | 0 | 2 | 0 | 2 |
F | ASIA | Linda | 3 | 0 | 0 | 1 | 2 | 0 | 3 |
G | ASIA | Jin | 0 | 2 | 0 | 0 | 0 | 0 | 2 |
H | ASIA | Ronald | 2 | 0 | 0 | 0 | 2 | 0 | 2 |
I | ASIA | Shiva | 17 | 0 | 0 | 1 | 15 (Dealer2) | 1 | 17 |
J | ASIA | Kenneth | 4 | 0 | 0 | 0 | 3 | 1 | 4 |
Appreciate your help.
Thanks,
May