YTD Calculation by Month

[djsampat]

Calculated YTD using the selected Month with a Graph comparing the Month by Account to the YTD Sales value.

[richard_pearce6]

Hi,

Best to use set analysis for better performance and change the expression to

= sum({1 <MonthId={"<=$(vMonthId)"}> }Sales)

Cheers