Page 1 of 1

Second filter

PostPosted: Mon Oct 31, 2011 5:41 am
by martinc
Hi,

Can I add a Second filter? I currently have a filter that cuts calendar items down to 400-500 items (Status "Not Done"). I'd like to have a second filter (Department Name or Project Manager) that I could apply. In that case I could create a new TO of the table and apply the second filter and have a calendar to each Department or Project Manager. Possible?

Re: Second filter

PostPosted: Mon Oct 31, 2011 6:53 am
by John Sindelar
Hi,

Zulu only supports one filter, so you'd want to create an auto-enter calc that returned the Department Name or Project Manager if the status was "Not Done", combining your two criteria into one filter so you get one calendar for each Department / Manager.

Hope that helps,

John

Re: Second filter

PostPosted: Mon Oct 31, 2011 8:24 am
by martinc
Thanks John,

I saw something in the help docs about avoiding calculated fields. I'll run with this.
Happy Halloween

Re: Second filter

PostPosted: Mon Oct 31, 2011 9:14 am
by JasonYoung
Hi Martin,

Auto-Enter Calculations should be ok, just not calculation fields, as the filter field needs to be writable. You may want to check this video out as it looks at filtering and auto-enter calcs:

http://www.youtube.com/watch?v=jfgYnHzakvA

hth,
Jason