Cumulative/Running Total

[MikeJones]

Hi, the top section below shows the output from a pivot table with the cumulative total when I use the following 

Aggr(RangeSum(Above(sum(Installs),0,RowNo())),WeekCommencing)

However, when I introduce a filter pane for week and choose week beginning 23 Jan, I get the bottom output.  What I wish to get is 1000 showing as the cumulative total.  How could I do this?

	02-Jan-23	09-Jan-23	16-Jan-23	23-Jan-23
Installs	100	200	300	400
Cumm	100	300	600	1000
	23-Jan-23
Installs	400
Cumm	400

[JHuis]

Hello,

what is your formula for cumm??

[MikeJones]

Hi, I am using 

Aggr(RangeSum(Above(sum(Installs),0,RowNo())),WeekCommencing)

to generate cumm

[JHuis]

Try:

Aggr(total RangeSum(Above(sum(Installs),0,RowNo())),WeekCommencing)

[MikeJones]

Hi, when I introduce your suggestion, all I get is a dash.

[JHuis]

I think i could do it cleaner, but i think this does the trick. 

[MikeJones]

Hi JHuis, thanks for your reply.  However, I don't have the ability to open a .qvf.  Could you please place it into a 'normal' reply area.

[JHuis]

i make 3 expressions:

Sum(Installs)

and

Sum(Installs)+Before(Sum( Installs))   and use  conditional hide GetSelectedCount(WeekCommencing)=0

and

Sum(Total {<WeekCommencing={"<=$(=Date(Max(WeekCommencing)))"}>} Installs) and use  conditional hide GetSelectedCount(WeekCommencing)>=1