Using Set Analysis for a MTD value to ignore a date selection but respect another selection

[danaleota1]

I am trying to create a column in a table that returns the Month to Date number of calls. I would like that it ignores any date filter selection but respects the agent filter selection.  

So far I have:

sum({1<Date = (Date)>} {1<IsCurrentMTD = {1}>} {$<Agent = (Agent)>} ACDCALLS) 

The MTD Column is returning the same values as the column for sum(ACDCALLS).  Any suggestions thanks.   

[sunny_talwar · Accepted solution]

Try this

Sum({<Date, IsCurrentMTD = {1}>} ACDCALLS) 

Or this if you want only Agent selection to have an impact

Sum({1<IsCurrentMTD = {1}, Agent = $::Agent>} ACDCALLS) 

[danaleota1]

This is working-- thanks @sunny_talwar !!