Set Analysis to fetch associated field value based on Max Date

[lightsection]

I would like to fetch the last value of "Cummulative Revenue Budget CAD" based on selected date period flag (Selections shown on the left side of the screenshot) 

[vamsee · Accepted solution]

Try

Sum({<[Actual Date]={"$(=Max([Actual Date]))"}>}Cummulative Revenue Budget CAD)

[lightsection]

Thanks. that works !