Straight table

[marishnagendran]

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????

[marishnagendran]

Thanks Petter.

It's Working