QS Rangesum Not show all Values

[hoangly]

Hi All,

I have a a table, and I need a Accumulate Chart for all Values. 

My table has Week Start in 201906. Using Rangesum function I can get Cumulative Values.

But when I try  to show in the Chart Weeks starting from week 22, all values of weeks before that week have been ignored in the cumulative calculation.

The Chart should have in week 22 , value 675989 (this is the **bleep** Value till w22), and Not 25165 (this is the weekly value of w22).

Any idea on sort out this?

Thank you!

Ly.

[Lisa_P]

This should work:
rangesum(above(
Total sum({$< WeekYear = {">= 201922"} >}
[Weekly Qty] )
,0, rowno(Total)))
+
sum( {<WeekYear={"<201922"}>}[Weekly Qty] )

[hoangly]

Hi Lisa_P,

thank you for your reply, but unfortunately it did not work, since I got wrong value and wrong visualization as well.

[hoangly]

Hi, Anyone has some idea ?

Thank you!

[Lisa_P · Accepted solution]

sorry, second part should be
+
sum( TOTAL {<WeekYear={"<201922"}>}[Weekly Qty] )

[hoangly]

Thank you. it works!