All Collections
Use Cases
AE Use Cases
Grid View for Closed Won Opportunities
Grid View for Closed Won Opportunities
Let's create a view that lets you see how you're tracking against your quota!
Cassie Adkins avatar
Written by Cassie Adkins
Updated over a week ago

Picture this: it is the end of the month or the quarter and you are trying to find all the closed won deals you worked so hard for! Or, you want to track how many you are going to close but don't want to have to search for all the opportunities in Salesforce.

We've got you covered!

  1. From your Opportunities Pipeline, either create or duplicate a new grid view.

  2. Go to Fields and bring in: closed date, stage, and amount/ACV

  3. Add this filter: [Stage] [is] [Closed Won]

    **Remove [Closed] [is] [false] if present.

  4. For last month/quarter, add this filter: [Closed date] [is] [Last month] or [Last Fiscal Quarter]

  5. If we want to track for the current month/quarter, all we have to do is add this filter: [Closed date] [is] [This Month] or [This Fiscal Quarter]

  6. To see the total sum of in the "amount/ACV/ect" column, select "calculate" and then hit "sum" to get the exact amount

    πŸ‘‰ If you want to create both of these views, all you have to do is duplicate the first view and change the filter accordingly


Book a Complimentary 1:1 with a member of our User Delight team today!


Related Articles:

  • Questions? Chat with us in the corner through WISH or email us at [email protected]

  • Ready to make your sales team happy? Talk to sales or learn how to purchase Scratchpad here.

Did this answer your question?