Equation Works On Selection but not on whole table

[Anonymous]

I have the following equation which works when I select a specific record which has a specific AGE ... However, when this is displayed on a table with NO selections, it does not work. I provided what the data looks like below as well. What am I missing so that it shows the calculation per person on the table when there is no selection?

=Sum({<CreatedDate={"$(='>=' & Date(Today()-AGE, 'M/D/YYYY'))"}>}Upsell_ARR__c)

Person/Age

Bob/20

Phil/30

Jen/50

Person/CreatedDate/UpsellARR

Bob/11/20/2017/$10

Phil/12/20/2017/$20

Jen/3/1/2018/$30

[sunny_talwar · Accepted solution]

Since you need dimension wise condition, set analysis isn't going to work... try this may be

Sum(If(CreatedDate >= Today() - AGE, Upsell_ARR__c))

[sunny_talwar]

Or this

Sum(Aggr(If(CreatedDate >= Today() - AGE, Upsell_ARR__c), Person, CreatedDate))

[Anonymous]

Thank you as always Sunny!