---
title: Monthly or YOY Reporting in Salesforce with Rollup Helper & Lookup Helper | Rollup Helper Use Case Library
description: A step by step walkthrough of combining Rollup Helper and Lookup Helper for Year over Year or Monthly Reporting.
---

[GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779

[![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com)

- Solutions 
    - By User Type 
          - [Admins](https://www.passagetechnology.com/en/solutions/salesforce-admin) 
                  - [Getting Around Rollup Limitations](https://www.passagetechnology.com/en/solutions/salesforce-admin#rollup-limitations)
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-admin#Reports)
                  - [GDPR Compliance](https://www.passagetechnology.com/en/solutions/salesforce-admin#GDPR)
                  - [Data Cleanup](https://www.passagetechnology.com/en/solutions/salesforce-admin#cleanup)
          - [Project Managers](https://www.passagetechnology.com/en/solutions/salesforce-project-managers) 
                  - [Managing Internal Projects](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#internal-projects)
                  - [Collaborate on External Projects & Client Status Reporting](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#External)
                  - [Project Analytics](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#Analytics)
                  - [Salesforce Training for Project Management Success](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#SF-training)
          - [C-Suite](https://www.passagetechnology.com/en/solutions/c-suite) 
                  - [Business Insights](https://www.passagetechnology.com/en/solutions/c-suite#business-insights)
                  - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/c-suite#decision-making)
                  - [Project Planning & Managing Execution](https://www.passagetechnology.com/en/solutions/c-suite#managing-execution)
                  - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/c-suite#custom-solutions)
          - [IT Managers](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce) 
                  - [Security & Compliance](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#security)
                  - [Enabling Salesforce Users](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#enabling-team-members)
                  - [Managing IT Projects](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#projects)
                  - [Avoiding Technical Debt](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#avoid-technical-debt)
          - [Salesforce Analysts](https://www.passagetechnology.com/en/solutions/salesforce-analysts) 
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-analysts#reports)
                  - [Project Management](https://www.passagetechnology.com/en/solutions/salesforce-analysts#project-management)
                  - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/salesforce-analysts#custom-solutions)
    - By Industry or Cloud 
          - [Software](https://www.passagetechnology.com/en/solutions/computer-software-industry) 
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/computer-software-industry#reports)
                  - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/computer-software-industry#decision-making)
                  - [Project Management](https://www.passagetechnology.com/en/solutions/computer-software-industry#project-management)
                  - [Security & Compliance](https://www.passagetechnology.com/en/solutions/computer-software-industry#security)
          - [Healthcare & Life Sciences](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud) 
                  - [Project Management](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#project-management)
                  - [HIPAA Compliance](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#hipaa)
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#reports)
                  - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#custom-solutions)
          - [Financial Services](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud) 
                  - [Relating Custom Objects](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#custom-objects)
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Reports)
                  - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#data-quality)
                  - [Compliance](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Compliance)
          - [Nonprofit](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud) 
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#reports)
                  - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#data-quality)
                  - [Project Management](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#project-management)
- Products 
    - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview)
    - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview)
    - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview)
    - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview)
    - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview)
    - [Work Trail](https://www.passagetechnology.com/work-trail-overview)
- [Support](https://www.passagetechnology.com/support) 
    - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-training)
    - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-training)
    - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-training)
    - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-training)
    - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-training)
    - [Work Trail](https://www.passagetechnology.com/work-trail-training)
    - [Services](https://www.passagetechnology.com/developmentservices)
    - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/)
    - [Log a Support Case](https://www.passagetechnology.com/contact-us)
- [Resources](https://www.passagetechnology.com/resources) 
    - [Blog](https://www.passagetechnology.com/passage-technology-blog)
    - [Customer Success Stories](https://www.passagetechnology.com/customer-success)
    - [Essential Guides for Business Transformation with Salesforce](https://www.passagetechnology.com/en/essential-guides-for-business-transformation-with-salesforce)
    - [Use Case Libraries](https://www.passagetechnology.com/use-case-libraries)
    - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/)
    - [Release Notes](https://www.passagetechnology.com/release-notes)
- [Company](https://www.passagetechnology.com/about) 
    - [About Us](https://www.passagetechnology.com/about)
    - [Press & Testimonials](https://www.passagetechnology.com/press-testimonials)
    - [Contact Us](https://www.passagetechnology.com/contact-us)
    - [Partners](https://www.passagetechnology.com/partners)
    - [Careers](https://www.passagetechnology.com/working-at-passage)
- [Search](https://www.passagetechnology.com/search)

# Monthly or YOY Reporting in Salesforce with Rollup Helper & Lookup Helper

[![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers)

## Problem: I need Monthly reporting to show the amount of open Opportunities this month. This could also be done for Year-over-Year reports.  

## Solution: You can use Rollup Helper and Lookup Helper together.

For this example, we will do monthly reporting. 

- From Setup > Object Manager 
    - Create a Reporting Month custom Object
    - Create Lookup relationship Field from Opportunity to Reporting Month, called Reporting Month
    - Create new Formula Field on Opportunity to pull Month and Year from an Opportunity, called Reporting Month Formula 
          - Set return type to Text
          - Use "Advanced Formula" 
          - TEXT (MONTH (CloseDate)) + "-" + TEXT (YEAR (CloseDate))
    - Create new Currency Field on the Reporting Month Object, called Open Opps Closing this Month 
          - Set number decimal places to 2
- Go into Lookup Helper to automatically relate Opportunities to Reporting Months 
    - Create new Lookup Helper setting
    - Select Child Object as Opportunity
    - Maintain Existing Lookup Relationship, using the Reporting Month field
    - Field on Opportunity you want to match is the Reporting Month Formula field 
          - Enable Create New Category Records
    - Save and run setting
- Use Rollup Helper to aggregate Opportunity information on the Reporting Month 
    - Create new Rollup Helper setting
    - Target Object is Reporting Month
    - Target Field is Open Opps Closing this Month
    - Child Object is Opportunities
    - Select Type of rollup as Sum
    - Field on Opportunity should be Amount
    - Create new filter to choose only Opportunities closing that month 
          - Filter criteria should be Stage, not equal to, Closed Won
          - Another filter criteria is Stage, not equal to, Closed Lost
          - Save filter
    - Save and run rollup

You can also watch this video walkthrough for more details. 

Tags: [Custom Object](https://www.passagetechnology.com/rollup-helper-use-cases/topic/custom-object), [Opportunity](https://www.passagetechnology.com/rollup-helper-use-cases/topic/opportunity), [Rollup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/rollup-helper), [Lookup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/lookup-helper), [reporting](https://www.passagetechnology.com/rollup-helper-use-cases/topic/reporting)

| [** How to Categorize Customers by Order Date in Salesforce ](https://www.passagetechnology.com/rollup-helper-use-cases/categorize-customers-by-order-date) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Number of Open Projects on an Opportunity ** ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-open-projects-on-an-opportunity-counting-a-custom-object-with-a-dynamic-filter) |
| --- | --- | --- |

[ Optimize Sales Rep Reporting and Leaderboards in Salesforce ](https://www.passagetechnology.com/rollup-helper-use-cases/sales-rep-reporting)

[ Rolling Up Marketing Cloud Account Engagement (Pardot) Activity ](https://www.passagetechnology.com/rollup-helper-use-cases/rolling-up-marketing-cloud-account-engagement-pardot-activity)

[ Streamline Sales Pipeline ](https://www.passagetechnology.com/rollup-helper-use-cases/streamline-sales-pipeline)

[ Creating Grandchild Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/creating-grandchild-rollups)

[ Calculate the Number of Cases on a Salesforce Contact Record ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-cases-on-a-contact)

[ Creating Account Hierarchy Rollups without Coding ](https://www.passagetechnology.com/rollup-helper-use-cases/account-hierarchy-rollup-without-code)

[ Easily Create a Custom Last Activity (Task/Event) Date ](https://www.passagetechnology.com/rollup-helper-use-cases/last-activity-task-event-date)

[ Roll-ups Using Formulas Rather than Static Criteria ](https://www.passagetechnology.com/rollup-helper-use-cases/roll-ups-using-formulas-rather-than-static-criteria)

[ Using Rollup Helper For Your Flow ](https://www.passagetechnology.com/rollup-helper-use-cases/using-rollup-helper-for-your-workflow)

[ Identify The Primary Contact On An Account ](https://www.passagetechnology.com/rollup-helper-use-cases/identify-the-primary-contact-on-an-account)

![Salesforce certified services by trusted Passage Technology](https://www.passagetechnology.com/hubfs/Salesforce/SF%20Partner%20Badges%202026%20(for%20footer).png)

Explore

- [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview)
- [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview)
- [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview)
- [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview)
- [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview)
- [Work Trail](https://www.passagetechnology.com/work-trail-overview)

Services

- [Custom Development Services](https://www.passagetechnology.com/developmentservices)
- [Milestones PM+ Starter Packs](https://www.passagetechnology.com/milestones-pmplus-starter-packs)

Learn

- [Support Portal](https://www.passagetechnology.com/support)
- [Resources Portal](https://www.passagetechnology.com/resources)

Company

- [About](https://www.passagetechnology.com/about)
- [Careers](https://www.passagetechnology.com/working-at-passage)
- [Press & Testimonials](https://www.passagetechnology.com/press-testimonials)
- [Partners](https://www.passagetechnology.com/partners)

Questions?

- [Contact Us](https://www.passagetechnology.com/contact-us)
- +1 (224) 655-6779

[GET DEMO](https://www.passagetechnology.com/any-product-one-on-one)

© 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496)

- [** ](https://www.facebook.com/passagetech)
- <https://x.com/passagetech>
- [** ](https://www.linkedin.com/company/passage-technology)
- [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Susan Harris",
    "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/susan-harris"
  },
  "dateModified" : "2026-05-29T20:01:35.191Z",
  "datePublished" : "2017-11-30T16:29:06.000Z",
  "headline" : "Monthly or YOY Reporting in Salesforce with Rollup Helper & Lookup Helper",
  "mainEntityOfPage" : {
    "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/monthly-or-yoy-reporting-in-salesforce-with-rollup-helper-and-lookup-helper",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png"
    },
    "name" : "Passage Technology LLC"
  }
}
```