how Sum if left (3 digits) are the equal to a field?
 

it is a pivot table, but I want to add two columns for total by row based in
the first three digits.

Pivot Table
I want to add.
Date STP-42 STP-45 STP-50 ACD-10 ACD-50 STP-total
ACD-total
9/20 1 2 1 2 2
3 4
9/21 1 2 1 2 2
3 4
9/22 1 2 1 2 2
3 4 9/23 1 2 1
2 2 3 4




please help.

Thanks
Ld

--
Lorenzo DÃ*az
Cad Technician