Hello,
I want to calculate the cumulative of VariableC in a new column. I have straight table (in diagram mode) with the variables:
- VariableA = itemNo
- VariableB = number of itemNo (calculated in load script)
- VariableC = more specific number of itemNo (calculated in load script)
In the table (diagram mode) I sorted VariableC in descending order.
I have tried to calculate the cumulative values of variableC with the following formula :
RANGESUM(ABOVE(SUM([VariableC]),0,ROWNO(TOTAL)))
RANGESUM(ABOVE(SUM([VariableC]),0,ROWNO()))
They both return the exact same values as VariableC, not an accumulation. Can someone help me?
Thank you!