RangeSum

[Guiqiang]

Hello everyone,  

I have a problem with RangeSum, I want to hide the red line from June to December 2024, this part of the fold does not make any sense in the chart. How do I hide it? Thank you!

Additionally，Grey and black lines need to show data for 12 months of the year.

The measure used for the red line: RangeSum(Above(SUM({<Year={2024}>}QTY),0,RowNo()))

[MATC · Accepted solution]

Hello,

You can for example use if statement to exclude future from the graph e.g. as below

if(month(today())>=Month,RangeSum(Above(SUM({<Year={2024}>}Qty),0,RowNo())),null())

I would also suggest instead of using "2024" in your set expression to use this as variables for current year, last year etc. so you do not have to worry about them every year change.