Hi,
I'm trying to create a search or a report which shows the total number of items added to an opportunity, that have been assigned a specific class. I have tried a few things but not sure if I'm starting in the right place, hence this reach out for advice. Where X is the name of a Class (they are quite complex) The main 4 fields I need to see are:
Customer Name, Opportunity Name, Document Number, Total Qty of Items where Class = X
After that, I may also need to filter/adjust the following criteria: Class (eg swap X to Y), Forecast Type, Estimated Close Date, Entity Status, Estimated Completion Date (custom opportunity field). I may also need to filter on project start date and project end date, but this would be a secondary / nice to have requirement
Given this requirement & info, should I start with a Search or with a Report? Should I start with a transaction search/report or an item search/report? And how can I display the summary total of those items on the record, rather than listing each item individually and repeating the opportunity info (which is what one of my attempts in a saved search did).
Thanks,
Chris