Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can somebody help me please
I would like to have the data of the previous month to the selected month using SetAnalysis.
Here are the data I have
I'd like to have if I select 04/01/2018 or 01/01/2018 the Sum of Value_FD where Month = Dec-2018 (45) and so on... If I select 25/12/2017 or 03/12/2017 or 21/12/2017 I'll have the Sum of Value_FD where Month = Nov-2018 (61)
Thanks in advance
Part of data :
DATA :
LOAD Date(FULL_DATE) as DATE,
Value_FD
INLINE [
FULL_DATE, Value_FD
01/01/2018, 5
04/01/2018, 5
25/12/2017, 10
03/12/2017, 17
21/12/2017, 18
02/11/2017, 56
05/11/2017, 5
];
Check this for text box object
=Sum({<DATE = {"$(='>=' & Date(MonthStart(Max(DATE), -1)) & '<' & Date(MonthStart(Max(DATE))))"}>}Value_FD)
Where do you want to show this value in a text box object?
yes
Check this for text box object
=Sum({<DATE = {"$(='>=' & Date(MonthStart(Max(DATE), -1)) & '<' & Date(MonthStart(Max(DATE))))"}>}Value_FD)
Thanks stalwar1
You are the best.