Pivot addition of previous rows

[mahendragaur]

Hello All,

I want to add previous rows value in pivot of qlikview. Below is my table and expression 

if(Above(Material)=Material   ,    Above(Expression)-[C]+[B]  ,    [A]-[C]+[B])

 

It is working fine for same date but if date is different it treat it as separate row and doesn't add the expression value of previous day (last row).

[sunny_talwar · Accepted solution]

Try this

If(Above(TOTAL Material) = Material, Above(TOTAL Expression) - [C] + [B], [A] - [C] + [B])