Re: Exclude Filter from Affecting Chart when filter dimension is an expression
The field name is closed date, but the filter i am displaying is of the Month as below.
=if(Month(Closeddate) = vMaxMonth and Year(Closeddate) = vMaxYear, Month(Closeddate))
When i select the Month, all charts get filtered accordingly. I want to prevent the filtering in one chart alone now. I tried to create a field called 'ClosedMonth' in the table and tried it in place of above.
=if(Month(Closeddate) = vMaxMonth and Year(Closeddate) = vMaxYear, ClosedMonth))
But still no effect. When i use just 'ClosedMonth' in the filter instead of using the IF expression, it works fine i.e. i am able to prevent the chart from being filtered when month is changed.