Cumulative calculations in crosstable or charts - with selected periods

[markvandermeij7]

We have a weekly revenue;

We want to select 1 or more periods.

Both periods need to show correct revenue. This is not working.

We're not looking to use an "as-of" table, as this would complicate selection options.

Please see the screenshot below.
Formula such as below do not work.

sum({ <Year={"=$(=Max(Year))"},SEQ={"<=$(=Max(SEQ))"} ,YearWeek=>}Value )  (Works in textbox!)

AGGR( sum(Total { <Year={"=$(=Max(Year))"},SEQ={"<=$(=Max(SEQ))"} ,YearWeek=>}Value             )  ,YearWeek )

[sunny_talwar · Accepted solution]

Try this

RangeSum(Above(Sum({<Year = {"$(=Max(Year))"}, SEQ = {"<=$(=Max(SEQ))"}, YearWeek>} Value), 0, RowNo()))

*

Avg({<Year = {"$(=Max(Year))"}, SEQ = {"<=$(=Max(SEQ))"}>} 1)

 

[markvandermeij7]

Thanks! That most certainly fixes it for me!