Forum Discussion

Learner86's avatar
Learner86
Icon for Helper I rankHelper I
4 years ago

Calculate 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 ...
Learner86's avatar
Learner86
Icon for Helper I rankHelper I
4 years ago

PaulOlding: 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".

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
4 years ago

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'