MTD in textbox

[#1]

Hi All,

Would any one suggest me how to show MTD values in textbox.

Ex. If I select 03rd Dec then textbox should show Total of Dec in textbox.

I tried with Set analysis but I guess I put something wrong.

Please suggest.

Thanks in advance

[vinieme12]

Please post the expression you used and the date flags you have in your master calendar

YTQ, QTD, MTD and WTD

Period Presets: Compare Periods on the fly

[surendraj]

Did you try this...

sum({<Year={$(=Max(Year))},Date={'>=$(=monthstart(max(Date)))<=$(=max(Date))'}>}[Sales Amount])

[#4]

Hi Sir,

Not working sir,

I have Year = Years, Month=Months, Day=[Report Day].

If I select any [Report Day] it should show total of Request of same month.

Ex. If I select 10th Dec it should show total request from 01st Dec to 31st Dec.

Please help

[surendraj]

May be this..but I am not sure..

Sum({<Years=, Months=,DateField=, [Report Day]={">=$(=Num(MonthStart(Max([Report Day]))))<=$(=MonthEnd(Max([Report Day])))"}>} Sales)

Here you can apply your measure on set analysis.here I used sales as my expression.

Take the dimensions as you have..

[vinieme12]

if you have a Report Month! field

sum({<ReportYear={$(=Month([Report Day]))},[Report Month]={"$(=Month([Report Day]))"}>}[Sales Amount])