Reports 'and' 'or' funtion
Hello I am trying to create a report to show how long tasks in each project are taking, I've managed to select all the relevant columns by using the 'What' project builder section.
I want to see the full timeline but not all project will have completed all tasks yet which is why I am using the 'or' option, however this is pulling through all tasks completed in the early phase which I want to eliminate so I would like to add 'and' property status is at these stages only but I can't change 'or' to 'and' for one column only. The means that the report is useless.
Is there a way to do this, if not how do I pull off a report for what I'm looking for?
Any help would be apriciated.