Trying to add a filter to a combined analysis report
I've created a report that links Shared Activity with Product List to show Activity with Products associated. Its a huge report and I am interested in activities related to certain products only.
When I add a filter based on Product Name ie. Product Name Like 'Real Estate' it returns rows where the Product Name is blank. Product Name doesn't exist in the Activity subject area so I only have the filter set on teh Product List subject area -- which is not really working.
Is there any way to get this to work?