you can still use the normal rolling calculations with
1:an inline load where Rolling 3 Months,Rolling 6 Months, Rolling 12 Months are the field.
2: use if(getfieldselection(), .....) in expressions.
this way you can use whatever you want and you wont be hardcoding Rolling 3 Months,Rolling 6 Months, Rolling 12 Months,
lets say we have a "period" field where the value are 'Rolling 3 Months','Rolling 6 Months', 'Rolling 12 Months'
user can select any one of them or nothing at all
expression will be something like
pick(match(getfieldselections(period),'Rolling 3 Months','Rolling 6 Months', 'Rolling 12 Months')+1,expression for current month,expression for rolling 3 month ,expression for rolling 6months, expression for rolling 12 months)
use this expression where you want rolling month. Where ever you don't want to see rolling sum just use the normal expression for current period. i hope i am clear and this is what your requirement is.
ps: expression can contain typo error as typed directly in the reply. expression can be written in pick match as well as if-else
I have a similar kind of situation where my Reporting date field has data something like :-
30 Nov, 17
31 Oct, 17
30 Sep, 17
31 Aug, 17
My requirement is to extract Current month, Previous month and previous quarter from this field
If Reporting date = June 30 2017
Current month-end = June 30 2017
Previous month-end = May 31 2017
Previous quarter-end = March 30 2017
- multiple options (current/previous month end or previous quarter-end) can be selected at the same time
- the 3 options should dynamically update the reporting date drop down list with the selected dates
Following is the example image on ultimately how it could look like.Any suggestions please??
Thanks for coming back Pradosh.
What I meant in use case 2 was -Ability to multi select. For example if I click on Current Month and Previous Month, both values should be selected.
I have created a sample data for your reference.
Any suggestions on it plz.
286333.qvw 150.0 K