Not able to get PYMTD

[renuka_sasikumar]

Hi,

I have

LOAD StartDate,

     EndDate,

     Cycle,

     AutoNumberHash128(Year&''&Cycle) as CycleNo,

     Year as fYear

From ....qvd;

in which I m showing Revenue as per MTD but even I want to show PYMTD

and also I have done Interval Match.

I tried by creating Variable its picking the StartDate but not the EndDate for PYMTD.

Can anyone pls help me how to go about it.

Thanks & Regards,

Renuka

[dinuwanbr]

Hi,

Why don't you use set analysis for PYMTD? and if you upload the qvw file it will be easy to give you a solution. (by seeing above codes can't get an idea.)

-BR,

dinu1

[senpradip007]

Can you upload sample qvw?

[Anonymous]

MTD:

=SUM({<StartDate = , EndDate = {'>=$(=MonthStart(StartDate ))<=$(=Today())'}>}Cycle)

PYMTD:

=SUM({<StartDate = , EndDate = {'>=$(=MonthStart(StartDate,-12))<=$(=AddYears(Today(),-1))'}>}Cycle)

[renuka_sasikumar]

Hi,

Here is the atached File in which the StartDate & EndDate for same month But different Year it is different.

Thanks & Regards,

Renuka.