set analysis

[denis115]

Hi everyone!

I'm stucked...

Having dimension DBZ (sales-costs) that is calculated in script

I need to create a chart that will show current(selected date)  dbz, 1-30 days before dbz, 31-60 days  before dbz and so one,

Ive tried:  sum({$<DATE= {">$(=MAX(DATE-60))<$(=MAX(DATE)-31))"}> } DBZ)

and no results(((

help please

[sunny_talwar]

May be this

Sum({$<DATE = {">$(=Date(Max(DATE)-60))<$(=Date(Max(DATE)-31))"}>} DBZ)

[denis115]

Ive tried this but it didnt worked

[denis115]

Sum ( {<Month_NUM={"$(=max(Month_NUM)-1)"}>}DBZ)

where Month_NUM is number of month but its not good because when i will choose january it will not work

[sunny_talwar]

So use MonthYear instead... and use AddMonths() function to go back months

[denis115]

Sum({$<MonthYear = {">$(=max( MonthYear ))<$(=max( MonthYear )+29)"}>} DBZ)

doesnt work(

[sunny_talwar]

You need to provide more details as to how are you creating MonthYear in the script?