how to set data according to year-to-date

[#1]

Hi,

I have been think for past 2 months and still can't find a work around solution.

I have  2 years (Y2015 to the latest date of Y2016) data loaded from DB source.

Example has a Date columm data:

01/01/2015.......01/12/2015......01/02/2016....25/02/2016

If today is 08 Feb 2016 , and i want to compare the Y2016 year-to-date percentage over Y2015(01 Jan to 08 Feb 2015).

How can i do it??

[#2]

Check this out:

The As-Of Table

I'm using this kind of calendar to get YTD, Rolling 12, Rolling 6, Last Year, Last Month comparatives.

Hope it helps!

Regards,

[nagireddy_qv]

Hi,

May this sample app help to you..

[settu_periasamy]

May be try

Sum ({<Year={"$(=Max (Year))"},Date={"<=$(=Today ())"}>}Measure) /

Sum ({<Year={"$(=Max (Year)-1)"},Date={"<=$(=Addmonths(Date,-11))"}>}Measure)

[#5]

Hi Settu,

Where should i put this expression in?

Seem not working.