week caluclation

[#1]

Hi,

I need to sum up the before 4weeks sales in straight table When I select week in week listbox

Please help

[ecolomer]

Here you have an example similar but with month

For weeks is the same

[maxgro]

Sum({$ <week={">=$(=rangemax(0,max(week)-4))"}>}sales)

[Gabriel]

Hi Reddy,

Personal what I would do is to create Point In Time flags in calendar and use WeekToDate flag, where WeekToDate = 1 in your Set Analysis.

Here is a link Calendar with flags making set analysis so very simple which might be helpful.

Your Set Analysis expression will just be Sum({<%PiT_WeekToDate = {1} >}Amount)

Hope this is helpful