Bar will come after Quarter completed

[prma7799]

Dear All,

I have one chart with one dimension in that all data is showing perfectly but my requirement in below chart I want to display Q3 bar after it completed means after 31-Dec-15 .

I don't want to display bar for Q3.

PFA..

Thanks

[prma7799]

Hi Kush,

I tried this but not achieve the same .

Thanks

[tresesco]

=aggr(if( Day(max(Date))=Day(MonthEnd(max(Date))),MonthDimension), MonthDimension)

[prma7799]

Thanks to All...

[Kushal_Chawda]

try

aggr(if( max(Date))=MonthEnd(max(Date)),MonthYear),MonthYear)