Hello;
I have a table:

Code:
ID     Cat1       Cat2      Cat3
1                    4           2
2      3                         1
3      7            3           2
4                                5
I need to create an ouput like this:
Code:
ID     Cat1       Cat2      Cat3      MaxValue        Sum
1                    4           2          4                   6
2      3                         1          3                   4
3      7            3           2          7                   12
4                                5          5                   5
Any suggestions?
Thanks!