What is the use case? Are you going to be switching between year and quarter? Or do you only need to see the last quarter in the view? Can you use the quarter/year filter?
Yes, i want to swith between year and quarter. When displaying on Year filter it only makes sense to show the last month of the year i.e for period jan to dec, on display dec figure. when drilling down to a quarter show the last value of the quarter.