Calculate multiple cumulative in one table in Qlikview

[marcvw]

Hi All, 

We have a table whereby we need to perform mulitple cumulative calculations. Example is shown below. 

As variables we have period and employee number. 

We are only able to modify expressions, no scripts. 

Is it possible to calculate the cumulative columns in Qllikview? Appreciate your support in here. 

Total Gross	Total Deduction	Total Taxes	Net Pay				Gross Cumulative	Deduction Cumulative	Taxes Cumulative	Net payment Cumulative
2883.05	7.82	457.78	2373.01				2883.05	7.82	457.78	2373.01
3125.89	7.14	457.93	2623.69				3125.89	7.14	457.93	2623.69
3556.95	7.14	194.93	2712.79				3556.95	7.14	194.93	2712.79
4975.82	22.44	3.21	3047.89				4975.82	22.44	3.21	3047.89
5205.69	20.53	3.64	3299.80				5205.69	20.53	3.64	3299.80

[Brian_C · Accepted solution]

Hi 

The following expression will give you the cumulative gross per employee assuming you have both employee and gross as dimensions. If this gives you the correct result then repeat the expression for the deduction, taxes and net pay.

Aggr(RangeSum(Above(Sum(Gross),0,RowNo())),Employee,Gross)

Kindest regards

B