Hi all,
I'm trying to create a sum of fields inside a row, but I can't figure how to do it. This is my scenario:
I have a table with one line for each transaction.
A transaction is composed of single calls (A, B and C).
For each call, I have a RequestTime
My actual table:
T Service RequestTime A RequestTime B RequestTime C
---------------------------------------------------------------------
12 ms A 3 0 0
B 0 6 0
A 3 0 0
B 0 2 0
C 0 0 6
---------------------------------------------------------------------
56 ms A 2 0 0
B 0 4 0
A 3 0 0
B 0 2 0
C 0 0 1
I want to add 3 more columns with the each RequestTime column sum by row, to be like this:
T Service RequestTime A RequestTime B RequestTime C Total_A Total_B Total_C
-------------------------------------------------------------------------------------------------
12 ms A 3 0 0 6 8 6
B 0 6 0
A 3 0 0
B 0 2 0
C 0 0 6
------------------------------------------------------------------------------------------------
56 ms A 2 0 0 5 6 1
B 0 4 0
A 3 0 0
B 0 2 0
C 0 0 1
It's possible to do that?
Thank you
... View more