---
title: "Advice Column: Track Real-Time Year-to-Date Revenue to Last Year"
description: Want to compare partial year revenue per Account vs. last year? You need Rollup Helper, which can use formula fields with dates, unlike default Salesforce
---

[Passage Technology Blog | Salesforce Partner, AppExchange Developer ](https://www.passagetechnology.com/passage-technology-blog)

# [Advice Column: Track Real-Time Year-to-Date Revenue to Last Year](https://www.passagetechnology.com/passage-technology-blog/ask-pt-about-comparing-year-over-year-revenue-to-date-in-salesforce)

 Written by [PT](https://www.passagetechnology.com/passage-technology-blog/author/pt) | Apr 11, 2023

*Dear PT, *

*Comparisons can be an important factor in forecasting. At our company, we’d like to compare this partial year’s revenue Opportunity total for an Account to the same time period in the previous year. Are we going up, down, or flat? Salesforce® doesn't do this out of the box. Can Rollup Helper help us?*

*Totul Todayt from Trend, Denmark*

Dear Totul,

Absolutely! [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) allows you to use formula fields with dates to create rollups, addressing a limitation in Salesforce. With the right formula, filter and rollup, you can display real-time revenue totals for the current year to date alongside a similar period from last year. Besides improving forecasts, this information could help prioritize recently lagging or fast growing Accounts.

Learn the simple steps to [create real-time year-over-year comparisons](https://www.passagetechnology.com/rollup-helper-use-cases/2016/11/14/previous-year-to-date-won-opportunity-total).

Sincerely,

PT

***

Check out other [Ask PT advice columns](https://www.passagetechnology.com/passage-technology-blog/tag/ask-pt).

[Submit your own question to PT](https://www.passagetechnology.com/en/ask-pt). You may see it used in a future installment in this series.

[View full post](https://www.passagetechnology.com/passage-technology-blog/ask-pt-about-comparing-year-over-year-revenue-to-date-in-salesforce)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "PT"
  },
  "dateModified" : "2023-04-11T16:07:06.751Z",
  "datePublished" : "2023-04-11T16:07:06Z",
  "headline" : "Ask PT About Comparing Year-Over-Year Revenue to Date in Salesforce",
  "image" : {
    "@type" : "ImageObject",
    "height" : 500,
    "url" : "https://www.passagetechnology.com/hubfs/ASK%20PT%20gif15.gif",
    "width" : 500
  },
  "mainEntityOfPage" : "https://www.passagetechnology.com/passage-technology-blog/ask-pt-about-comparing-year-over-year-revenue-to-date-in-salesforce",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Passage Technology Blog"
  }
}
```