how to calculate accumulated values per month

[bumin]

Hi,

I have the attached Excel-File

I want to calculate the accumulated value per AssetID month and year

The expected values are in column F (result in Qlikview).

can anyone create the formula for this

I have tried with peek values but I didn't got it.

thanks

Bumin

[Gysbert_Wassenaar · Accepted solution]

Try this:

tabelle:

LOAD AssetID,

     recno,

     value,

     month,

     year,

     if(Previous(AssetID)<>AssetID, value, rangesum(value,peek(acc_value))) as acc_value

FROM

     (biff, embedded labels, table is Sheet1$);