set analysis for data display?

[Anonymous]

i have a month list box

month:

[

jan

feb

mar

.

.

.

.

.

oct

nov

dec

];

i made a bar chart with dimension as month and expressions as sum(sales).

my req is i dont want see the sales for current month and previous month.

for example we are IN  SEP so i dont want see sales for month of  sep,aug(current month and previous month)

if we moved to OCT then i dont want see sales for month of OCT and SEP  ?

[senpradip007]

Try like:

Sum({<Month={"<$(=Max(Month)-1)"}>} sales)

[Anonymous]

it will ignore last month only what about current month  pradip..

[Anonymous]

you want to see up to current month

Sum({<Month={"<$(=Month(today()))"}sales)

if you want to see only current and previous month

sum({<Month={">=$(=month(today()-1)<=$(=month(today()))"}sales)

[senpradip007]

Did you try with that expression?

[Anonymous]

no yar ,not yet

ok i will try tell u

[Anonymous]

i want exclude current month and previous month ,rest of the month i want to see

[Anonymous]

then

sum({<Month={"<$(=month(today()-1))">}sales)

should work