DTD and MTD

[#1]

Dear Gurus,

Could you please help me is resolving the below requirements.

Table:
LOAD * INLINE [
    Date, Exp 
    01/03/2015, 15
    02/03/2015, -5
    03/03/2015, 25  

    01/04/2015, 10

    02/04/2015, -5

    03/04/2015, 20

];

Requirements:

1. If 1/03/2015 select then result should be
Date            DTD      MTD
01/03/2015   15           15

2. If  01/03/2015 and 02/03/2015 Select  then result should be
Date               DTD      MTD
01/03/2015      15         15
02/03/2015      -5          10            (=15-5)

3. If 02/03/2015 and 03/03/2015 Select then result should be
Date            DTD   MTD
02/03/2015   -5      10                 (=15-5)
03/03/2015   25      35                 (=15-5+25)

4. If 02/04/2015 and 03/04/2015 Select then result should be
Date            DTD   MTD
02/04/2015   -5      5                 (=10-5)
03/04/2015   20      25                (=10-5+20)

Thanks in advacne and please do let me know in case of any clarification

[#2]

Please find the attached Document

[PrashantSangle]

Hi,

If Date is your dimension, For DTD just write sum(Sales)

and for MTD

Create Day field in Script and nullify it in expression

try like

sum({<Date={">=$(=date(min(Date)))<=$(=date(max(Date)))"},Day=>}Sales)

Regards

[#4]

Please find the attached Document

[timanshu · Accepted solution]

Hi,

PFA QVW App and Screenshot.

[senpradip007]

PFA. Hope it will help.