Requirement For quarterly data on yearly basis

[deepakqlikview_123]

hello all,

below is scenario

As per requirement if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A year,otherwise need to put Q4 data for FRQ type Q for  year

can you please suggest how to calculate data on yearly basis at backend.

as per requirement i need to show above data on stacked bar chart.

please find my attached sample data for this

please suggest on this

[deepakqlikview_123]

Hi Kush,

Thanks for reply it seems condition is as per requirement.

But as per new change if there is data for any one of three indicator is not there then i need to hide data for other two indicators also for that particular year.

eg- in our chart there is no data for 1998 and 1999 for indicator bank pvt debt to nominal GDP  then i need to hide bar

for year 1998 and 1999.

same condition is applicable for all 3 indicators (data should be there for all 3 indicators, if not skip the data irrespective of availability of data)

thanks

[Kushal_Chawda · Accepted solution]

Please see the attached

[deepakqlikview_123]

Thanks kush for your prompt reply.

Your solution rocked

I will test with my original data then i will update you.

Thanks