Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)