Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please post the expression you used and the date flags you have in your master calendar
Period Presets: Compare Periods on the fly
Did you try this...
sum({<Year={$(=Max(Year))},Date={'>=$(=monthstart(max(Date)))<=$(=max(Date))'}>}[Sales Amount])
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
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..
if you have a Report Month! field
sum({<ReportYear={$(=Month([Report Day]))},[Report Month]={"$(=Month([Report Day]))"}>}[Sales Amount])