sales stage history report combined with opportunity product revenue subject
I have a report where I need to show any opportunity where a specified stage (say, Open) was started between a set of dates input by the user.
the report also needs to bring in product. I have created a combined analysis report which brings in sales stage history, as well as opportunity product revenue subjects from the analytics area and i created a dashboard prompt and pull the report in a dashboard to allow for interactive filtering.
However, when i go to filter by sales stage start date, i'm not getting the correct results -- i'm assuming because this field doesnt exist in teh opportunity product revenue subject.