Date filed sections for YTD and MTD?

[#1]

Hi

I Have data from Jan -01 -2017 to Current date

now i am showing data like this

Country      daily        MTD              YTD   this is table structure

A                  10          20                 300

now in filter sections iam displayig    DailyDate

now if user selects May-05-2017 particular date this (Daily,MTD,YTD fileds are showing only single day data)

but i want daily filed (Single day data)

MTD Filed (user selcted May month so i want upto May-05-2017)

YTD (up to May-05-2017)

please help

thanks.

[#2]

.

[RonaldDoes]

Hi Chaganti,

Can you provide us with a QVD?

[mato32188]

Hi Chaganti,

try to use Set Analysis in your Expressions:

MTD = sum(   {<Year = max(Year), Month = max(Month), Date = {"<=$(=date(Today()))"}>}   ExpressionField)

YTD = sum(   {<Year = max(Year), Month, Date = {"<=$(=date(Today()))"}>}   ExpressionField)

BR

Martin