How i sum value between 30 days in each ID

[inoruoya]

i need to sum value in 30 days left from register date in each ID,

so i have data field "ID" and "RegisterDate" in table of  customer, and i have transaction of each customers paid on during  days. I use on this expression  "Sum({<Date={"<=$(=AddMonths(RegDate,1))"}>}PayAmount)"  , that expression return "0" ,but when i select in only 1 ID that can return in right sum value.

could you please help me for new expression for return result set on "No selection"

[vinieme12]

Expressions are evaluated only once per chart and not once per row,

basically you cannot have a different formula for each row in your table, Since each of your IDs have a different start and end date, this is not possible

You will have to create a new field in your datamodel table to flag the last 30 days for each ID and then use the flag field in your calculations