if(YEAR and QUARTER='$(=maxstring({<YEAR={$(=max(YEAR))}>}QUARTER))',YEAR))
,if(YEAR= '$(=max({<NAME={A,B,C,D}>}YEAR))'
and QUARTER='$(=maxstring({<YEAR={$(=max(YEAR))}>}QUARTER))', YEAR
))
Expressions are
=(Avg({<NAME={A},QUARTER={'Q4'}>}VALUE))
=(Avg({<NAME={B},QUARTER={'Q4'}>}VALUE))
=(Avg({<NAME={C},QUARTER={'Q4'}>}VALUE))
=(Avg({<NAME={D},QUARTER={'Q4'}>}VALUE))
Presently we are showing for the max year with quarter in the chart as dimension and we are restricting with quarter-Q4. But we have data for the latest year 2015 Q1,Q2 and we required to show fo only latest year as 2015 Q2 in the chart and previous years should be calculated only Q4 and shoudl be shown as 2012,2013,2014,2015-Q2.
