Hi,
I have a requirement wherein i need to have filters on Year Quarter wherein the Filters need to be split as From Year Quarter and to Year Qtr.
So the From Year Qtr Will have values like 2016Q1,2016Q2, 2016Q3, 2016Q4 and 2017Q1, whearas TO Year Qtr must have all values except the the min Year Qtr Available which would be 2016Q2, 2016Q3, 2016Q4 and 2017Q1.
I have acheived this in the script level by creating a table with all Year Qtr left joinned with All Year Quarters except the min Year Qtr available.
But this approach is very Time consuming as we need to traverse the complete table fetch the distinct Year Qtr available and then perform the logic.
Could anyone let me know if this issue could be addressed in any other way.
