Excel 2007 : How to calculate count of certain column values in a pivot table

[nvn_germany]

Hi,


For a column S, I have 4 set of values - S1, S2, S3 and S4. One more column T having values T1,T2 and T3 for which column S is used to indicate status. Pivot table can be drawn with T and S. With T in the row and S in the row and column.

T S1 S2 S3 S4
T1 4 4 5 6
T2 3 3 3 5
T3 2 1 4 5

My question is to have one more column S5 = S1 + S2 + S3

Resultant :

T S1 S2 S3 S4 S5
T1 4 4 5 6 13
T2 3 3 3 5 9
T3 2 1 4 5 7

How this can be done with pivot table? Any ideas are highly appreciated.