This content has been marked as final. Show 2 replies
I have a Date field: QE Date
I also have a parameter: Quarter End
Quarter End was created from QE Date. Data type of Quarter End is string. I cannot change the data type for other reasons.
Display format for Quarter End is: 2017 Q4, 2016 Q2 etc.
Now, I want to show last five years data based on the parameter selection. I have Quarterly data. For yearly data, it should show data for Q4 only
except for current selection.
Use Case 1:
If user choose 2016 Q2, data should display for: 2016 Q2, 2015 Q4, 2014 Q4, 2013 Q4, 2012 Q4
Use Case 2:
If user choose 2017 Q3, data should display for: 2017 Q3, 2016 Q4, 2015 Q4, 2014 Q4, 2013 Q4
Use case 3:
If user choose 2017 Q1, data should display for: 2017 Q1, 2016 Q4, 2015 Q4, 2014 Q4, 2013 Q4
Any help ?
Please remember, parameter is string format.