I would like to create a report showing all deals Lost, Cancelled or set On Hold last week, in ONE e
Nov 14, 2019 6:27 AM - edited Nov 14, 2019 6:28 AM
I would like to create a report showing all deals Lost, Cancelled or set On Hold last week (all in one report in the dashboard). I could create one box for each Deal Stage based on three Single object reports. But that would result in three boxes (out of the maximum of 10) in the dashboard.
- It’s not possible to use a Single object report to show all these deals in one report, because if you use more than one Filter, the second Filter ADDS to the first (you can’t choose OR). And there are no deals that have both entered deal stage Lost AND deal stage Cancelled last week…
- If I create a Cross object report, the property “Entered Stage Date” is not available under Filters, so the list will show all deals in Deal Stage Lost, Cancelled and On Hold, not only the deals that entered these deal stages last week.
Any answers would be very welcoming. Thanks 🙂