Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ronman10
Creator
Creator

Expression to Get YTD Values

Hi Guys,

 

I am trying to create a YTD chart where in a month selection should give YTD values till that month. For example, if I select February in the month filter the chart should show Sum of January + February value. Please assist.

 

Best Regards,

Rony

Labels (1)
2 Replies
ChiragPradhan
Creator II
Creator II

Hi Rony,

Use this expression.

Sum({$<Date={"<=$(=Max(Date))"}>}Value)

 

Regards,

Chirag 

ronman10
Creator
Creator
Author

Hi Chirag,

 

This expression is not adding up the months. If I select March only March values are showing up and not YTD March.

 

Best Regards,

Rony