The best is to use a date parameter which picks up any date in a quarter stands for the selected max quarter. If this is an acceptable workaround, I can show step by step with your sample workbook.,
1 of 1 people found this helpful
use the below approach to get your requirement
Step 1: Create a view with FY QTR and sum(sales) like below by dragging FY QTR to columns and SUM(Sales) to rows
Step 2: Create a String Parameter and add from the field FY QTR
Step 3: Create calculation below to capture the maximum index of selected quarter
Step 4: use the below calculation to validate the Quarter and quarter -1 and quarter -4
Step 5: use the validate quarter in filter and select true
now you will be able to view the report as per the quarter seletion
If user selects FY19Q2 as max qtr, i want to display sales of Fy19Q2, FY19Q1 & FY18Q2.
user selects FY18Q4 as max qtr, i want to display sales of FY18Q4,FY18Q3 and FY17Q4.
Hope this helps, mark this answer as correct or helpful so that it will help others
But FY QTR Param is static here. It wont get updated automatically right? Every time we should refresh the parameter by editing it.
Yes parameter are static with filter no way you can get the above approach as far as i know
Consider an example filter you are applying as FY17Q4 your sheet will show only respective selection parameter why we are using instead of filtering data we are using as static value to match with the dimension getting the requirement.
Hope this helps