Running total at max date

[#1]

Hi,

I'm using the following expression to accumulate figures in a column:

sum(aggr(
RangeSum(Above(
sum(
aggr(
sum({<ID = {'34'}>} Total <[Visit IP Country ISO],[Visit Date]> Signups)
,[Visit IP Country ISO], [Visit Date])
)
, 0, RowNo()))
,[Visit IP Country ISO], [Visit Date]))

This works well, but the expression total is the sum of the accumulated values, whereas I need the expression total to be the running total at the max date. Can anyone think of a way to add this logic to the expression?

Here's a screenshot illustrating the output I'm after. 235, the running total at max date should be the expression total instead of 1001:

I've attached an example below. Apologies in advance, this is a repost, but I'm in a pinch and would like to get some help on this soon.

Matt

[#2]

Attached with answer.

Select Max of Rows for Totals

Thanks

[#3]

[#4]

Hi Ajay,

Max isn't an option for me, it needs to be done with set analysis.

Any ideas how the expression can be modified to do this?

Matt

[#5]

May I ask why Max wont work for you. It gives the desired result, doesn't it.

[#6]

I need to use the expression alone in a text box as well as the straight table and the max option won't work there. In the straight table I'll also be dividing it to create another expression (see column 'CR BL' above) and need the expression total based on max date for this.

Best,

Matt

[#7 · Accepted solution]

I've wrapped the expression in this: max(aggr( exp , [Visit Date]))  and it's working.