Set analysis exp for selected year,month and upto selected day

[#1]

Hello,

I am trying to evaluate set analysis exp for selected  year ,month and upto selected day

i.e(if i select  may 2012 16 then yera=2012 ,month=05 , day= 1to 16)

i tried like this

=sum({<Yearp = {'$(Year)'} ,Monthp = {'$(Month)'} , Dayp = {' >=01   <=$(max(Day))'} >} Qty)

but not working pls  anybody can correct it for me.

Thank U.

[jagan]

Hi Pankaj,

Try like this, if you have a dimension

=sum({<DateDimension= {'<=$(=Date(Max(DateDimension)))'} , Yearp=, Monthp = , Dayp = >} Qty)

Note : Check the date formats are same in (=Date(Max(DateDimension))) and in DateDimension

Hope this helps you.

Regards,

Jagan.

[rwunderlich]

Is your selection made in a single Date field or three separate fields?

-Rob

[#4]

Hello sir,

Actually I have created master calender & linked with Posting-date  .

I am selecting calender's year ,Month & day by this posting-date automatically get filtered and Qty also bcoz both are linked with each other .

if i select calender  May 2012 16 then  posting-date is "05/16/2012" and Qty = 984 for 05/16/2012.

Qty also filtered but i want qty from 1 day of month to till date.

so  what u suggest sir.

Thank u

[#5]

Hi

Please try this.

=num(SUM( {<[FinMonth] = {"<=$(max(FinMonth))"},

[FinQuarterNum] = {"<=$(max(FinQuarterNum))"},

[FinYear] = {"<=$(Max(FinYear))"}>} QTy) ,' #,##0 '),

Regards,

Usman

[jagan]

Hi,

Try this

=sum({<DateDimension= {'<=$(=Date(Max(DateDimension)))'} , Dayp = >} Qty)

Regards,

Jagan.