Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please find the attached Document
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
Please find the attached Document
Hi,
PFA QVW App and Screenshot.
PFA. Hope it will help.