name set to until month

[ester_pr]

Hi,

I need help for creating name set to until mount, I an traing to write the sum of sales until the selected mount with no success

My set is

=

sum({$<YEAR={2011},month={$(=only(month))}>} ,SALES

I need to make it month <= only(month)

[ester_pr]

somehow when i write

sum({$<YEAR={only(year-1})}>} ,SALES

it's ok but

sum({$<month={only(month-1})}>} ,SALES

it returns 0, wite the -1 only, way?

[rajeshvaswani77]

Hi Ester,

       Please use AddMonths(date,-1) and extract the month from it.

Thanks,

Rajesh Vaswani