We have a scoring process with 5 categories. Scores range from 0-5. I have setup a custom field grid to capture this information in our JIRA tickets instead of Excel (which is what was used previously)
I understand how to add a total column at the end of each row but is it possible to have a total for the actual column?
column 1 | column 2 | column 3 | column 4 | column 5 | Total (for the row)
row 1| 5 | 3 | 2 | 4 | 0 | 14
row 2| 2 | 3 | 2 | 4 | 3 | 14
row 3| 5 | 5 | 5 | 5 | 5 | 25
row 4| 1 | 1 | 1 | 1 | 1 | 5
row 5| 13 | 12 | 10 | 14 | 9 | 58
(total for column)
I am trying to figure out can row 5 be: (c1,r1)+(c1,r2)+(c1,r3)+(c1,r4) = c1,r5