I'm creating a report that lists all of the account IDs from last fiscal year with a probability of 70% or greater. I've done this using the select expert, and all is well.
However, in the report footer section I'd like to add the total number of account IDs from last fiscal year, regardless of the probability. When I drag the account ID field into the report footer section and hit the select expert button, it already has the same selection criteria as the account id field in the details section. If I modify the selection criteria, it also changes the criteria for the account id field in the details section.
Is there any way around this? Is it even possible to have different selection criteria using the select expert on the same field, more than once in the same report? Or is there a better way to accomplish this that I'm not aware of?
However, in the report footer section I'd like to add the total number of account IDs from last fiscal year, regardless of the probability. When I drag the account ID field into the report footer section and hit the select expert button, it already has the same selection criteria as the account id field in the details section. If I modify the selection criteria, it also changes the criteria for the account id field in the details section.
Is there any way around this? Is it even possible to have different selection criteria using the select expert on the same field, more than once in the same report? Or is there a better way to accomplish this that I'm not aware of?
Facebook
Twitter