Sum of Value for Date - 30

[danm84306]

Hello,

      I am looking for some Set Analysis help. I need to sum Dimension A only for dates that are the Max Date of Value B - 30 days. Nothing I am finding helps, any ideas?

something like

Sum({<Max(Date_B)-30>} Value_A)

[andrey_krylov]

Hi Dan, maybe this

Sum({< Date_B = {"=Rank(num(Date_B)) = 30"}>} Value_A)

or this

Sum({< Date_B ={"=Rank(num(Date_B )) <= 30"} >} Value_A)