Set Analysis expression help

[bismart]

I have a transaction table with several years of transactions.

I want to create a measure which equates to the total of transactions up to and including selected Year & month or Yearmonth, e.g. 201006 = June 2010.

Can anyone help please

Thanks

[pover · Accepted solution]

Bismart,

Try something like this...

sum({$<Year=,Month=,Quarter=,MonthYear={"<=$(#=max(MonthYear))"}>} Amount)

Regards.

[bismart]

Thanks Karl

Just what I was looking for

regards