Filter

[smilingjohn]

Hi Expertise ,

Iam using  the below expreesioon in a straight table ..and there are 4 expression like the below..

I have 3 filters ( Dept, Agency,Date)

=Sum({<PeriodType={'CurrentOpen'},DefectCountLoadDate={">=$(=Date(addmonths(Max(DefectCountLoadDate))))"}  >} OpenCount)

Now i want to exclude the selection made for the filter "Agency " in the straight table and other filters should work normally .

And there are different tables  which should reflect the changes normally

How can i acheive this Please Expertise help me

Thanks in Advance

[Anil_Babu_Samineni]

Like this?

=Sum({$<Agency=, PeriodType={'CurrentOpen'},DefectCountLoadDate={">=$(=Date(addmonths(Max(DefectCountLoadDate))))"}  >} OpenCount)

[smilingjohn]

Hi Anil ,

In a caption iam using The date accordingly ,

How should i use the same here ?

Date(Max(DefectCountLoadDate), 'MMM-YYYY')

?

[Anil_Babu_Samineni · Accepted solution]

You can do even with Max

Date(Max({$<Agency= >} DefectCountLoadDate), 'MMM-YYYY')

[Kushal_Chawda]

try this

Date(Max({<Agency>}DefectCountLoadDate), 'MMM-YYYY')

[smilingjohn]

Thanks a lot Anil Sir