Showing data in chart

[deepakqlikview_123]

Hi All,

PFA

Below is condition.

For max year if quarter is Q4 is present then show annual data otherwise show quarterly data.

For all years except max year show annual data

We have applied some logic to get result. It seems fine.

Can you please suggest on this.

Thanks

[Anonymous]

Hi deepak ,

You can right the condition like this ,

if(Year=max(year)<>'Q4',Quarter,

if(Year= max(year-1),Year)

Like this using 'if' condition based on selections with  using sets.

I suggest like this if possible .

I will try another way and let u know

thanks ,

Bunny