Dear PT,
Our company displays products, quantity, and revenue on our Opportunity records. Unfortunately, the revenue figures are from the last 12 months to date, so the total may span two different years. We need to separate the revenue into two different categories, this year and last year. And we’d also like to display this information at the Account level. What do you suggest?
Rev. Nu Kalander from Fields, IN
Dear Rev,
The good news is you can easily build the required Rollup Summary Fields with Rollup Helper. This would create annual revenue fields for every Opportunity and Account—in a span of minutes using clicks not code. Problem solved!
The multi-step rollup configuration is outlined here, explained in detail.
Sincerely,
PT
***
Check out other Ask PT advice columns.
Submit your own question to PT. You may see it used in a future installment in this series.