Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement were i need to provide filters to user which will work like below.
Eg:-
if we have a filter for month (it is a fiscal calendar), and the user selects June then Apr, May & June all three months should be selected automatically, if user selects Sep then Starting from Apr to Sep all the months should get selected.
i.e whenever there is selection of month made, all the months starting from Apr to the selected moth should get selected.
Hope i was clear enough, Thanks in Advance!!
Regards,
Saniya
Hi,
Created an Inline for months and month no & it worked.. thanks.
Regards
Saniya
You meant to say You have data since Apr only
Try like below, Make sure you month format should be MMM then only this will work or else it may thread
Sum({<Month = {'>=$(=Min(Month)) <=$(Max(Month))'}>} Sales)
Hi,
I am trying the same but the trigger is not working as expected, will retry and let you know.
Regards,
Saniya
Have implemented the same to calculate YTD Sales, but the values are not matching once any selection on month is made
Look at this? May be YTQ, QTD, MTD and WTD
Hi Saniya,
Use Sum({<Month = {'>=1 <=$(Max(Month))'}, Year = {'$(=max(Year))'}>} Sales)
Here the month is explicitly stated to start from April (if April is marked as month 1 - as its a fiscal year) upto the month selected.
Hi,
Created an Inline for months and month no & it worked.. thanks.
Regards
Saniya
HI Saniya.
I suggest you make a inline for eg:
Load * inline [
MonthSelected, Month
Apr , 1
May, 1
May, 2
];
Hope it will help.