Forum Discussion
Learner86
Helper I
Helper ICalculate sum over multiple rows
Dear Community, I need your help again. Imagine I have the following table ID Column 1 Column 2 Column 3 5 100 30 10 6 50 15 80 7 70 60 90 Sum 220 105 180 ...
PaulOlding
Solution Sage
Solution SageYou could add a new measure that adds Column1, Column2 and Column 3
Sum Rows = [Column 1] + [Column 2] + [Column 3]
The matrix visual has row totals when you use field(s) in the Columns field well.
Learner86PaulOlding: I used this formula before but it doesn't work. The matrix visual doesn't help me because I can't use the field "column".
- Learner86
I could solve the problem.
- PaulOlding
In what way does it not work? Error message? wrong result?
My assumption was you have 3 measures called 'Column 1', 'Column 2' & 'Column 3'