YTD & MTD

[NavinReddy]

Hi Community,

I have a table like this, i need to be find out the YTD and MTD Calls

Day of the Calls,

Year to date Calls,

Month To date Calls

could some help me

LOAD

     MTD,

     YTD,

     Metricid

FROM

(ooxml, embedded labels, table is Sheet1);

Thanks,

Rohith

[#2]

Try this....

Take Date field(DD/MM/YYYY) in script level..then try expression

YTD:

Sum({<Date={'>=$(=(Num(YearStart(Max(Date)))))<=$(=(Num(Date)))'}>}Calls)

MTD:

Sum({<Date={'>=$(=(Num(MonthStart(Max(Date)))))<=$(=(Num(Date)))'}>}Calls)

[er_mohit]

See the attached file

[NavinReddy]

Hi mohit ,

Thanks a lot

Plz find the attachment,let me know if i roung

Rohith