Set Analysis Month Query

[Anonymous]

Hi,

I am trying to get a sum of the amount of lines sold for this current month using set analysis  with the following:

SUM({$<Month([Order Date]) = {month(today())}>} [Line Amount])

I am getting errors, any ideas?

Thanks in advance

[shraddha_g]

Sum({<[Order Date] = {">=$(=Date(MonthStart(max([Order Date))))<=$(=Date(Max([Order Date])))"}>}[Line Amount])

[shraddha_g]

You can also create month field in Script as

Monthname([Order Date]) as Month

Use this in Set Analysis

Sum({<Month = {"$(=Maxstring(Month))"}>}[Line Amount])

[Anonymous]

Thankyou for your help, worked perfectly