I have a table containing sales leads. Each lead has a type, salesperson and a date created. I have a report showing total number of leads of type A against each salesperson - this is done by using the select expert to filter the leads to include only type A.
My problem is I want a second column to show the number of leads of type A which have a date created value that falls within a date range that I am entering as a parameter field. This is effectively a subset of the first column data. Is there an easy way to do this?