Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can do even with Max
Date(Max({$<Agency= >} DefectCountLoadDate), 'MMM-YYYY')
Like this?
=Sum({$<Agency=, PeriodType={'CurrentOpen'},DefectCountLoadDate={">=$(=Date(addmonths(Max(DefectCountLoadDate))))"} >} OpenCount)
Hi Anil ,
In a caption iam using The date accordingly ,
How should i use the same here ?
Date(Max(DefectCountLoadDate), 'MMM-YYYY')
?
You can do even with Max
Date(Max({$<Agency= >} DefectCountLoadDate), 'MMM-YYYY')
try this
Date(Max({<Agency>}DefectCountLoadDate), 'MMM-YYYY')
Thanks a lot Anil Sir