How to accumulate the values of a column to another column

[#1]

Hi,

I'm newcomer zu QV and I'm facing the folowing problem:

There is table with the following structure.

(Member, Month, Type, Value)

I have also a table diagram, with the structure

(Member, Month, Invoiced, Ordered)

Invoiced is created from Value where Type = 1  I.e. Invoiced = Sum ( {<Type ={ 1}>} Value)

Orderd is created from Value where Type = 2   I.e. Ordered = Sum ( {<Type ={ 2}>} Value)

How can I create a new column (Formular) that accumulates the values of Invoiced within Member incl all Month's

Thanks in advanced

Udo

[Gysbert_Wassenaar · Accepted solution]

Sum ( {<Type ={ 1}>} total <Member> Value) will give you the total over all months for the member.

If you want a running total you can use the above() function: rangesum(above(Sum ( {<Type ={ 1}>} Value),0,rowno())). As long as Member is the first dimension and Month the second the rangesum should restart if Member changes.

[#3]

Hi Gysbert, thanks for your help, The running total solution could solve my problem,

Best regards.

Udo