4 Replies Latest reply on May 9, 2011 10:57 AM by stebr

    "all choices" in dashboard prompt


      i created a filter prompt for a dashboard report containing the field "current sales stage". The choices in the prompt are limited by an sql-query:

      SELECT Opportunity."Current Sales Stage" FROM "Opportunity Analysis" WHERE Opportunity."Current Sales Stage" in ('1 Opportunity Development', '2 Bid Preparation', '3 Contract Negotiation')

      My report contains two filters:
      1. "current sales stage" is prompted
      2. "current sales stage" in (1 Opportunity Development, 2 Bid Preparation, 3 Contract Negotiation)

      But when selecting "all choices" in the dashboard all opportunities are shown in the result, even those that are won/lost.

      Does anyone know how to fix this?