We needed a way to show lists of opportunities on a rolling 12 months basis, or for the next 365 days.

Since neither of these functions were available for Opportunity reports, I had to create a custom object, with a formula to be able to get these.

I was able to create a formula for an Opportunity report for a rolling 12-month report, it should also work for a Trailing Twelve Month. 

First, create a custom object with a formula.  I called mine Rolling Date

The formula was:

IF(End_Date__c<=TODAY() +365, 1, 0)

In English, if the End Date of our opportunity is greater than or equal to Today's date plus 365 (days), return 1 if true, and 0 if false.

THEN: when creating the report I just filter by the names of the folks I want to include and Rolling Date equals 1.

The formula won't work for Text, it has to be Number. 

It works great, and I assume that by changing the + 365 to a - 365 it will create a TTM report. 

I can't believe that there's no Next 365 or Last 365 in the drop-down for report duration.

We needed a way to show lists of opportunities on a rolling 12 months basis, or for the next 365 days.

Since neither of these functions were available for Opportunity reports, I had to create a custom object, with a formula to be able to get these.

I was able to create a formula for an Opportunity report for a rolling 12-month report, it should also work for a Trailing Twelve Month. 

First, create a custom object with a formula.  I called mine Rolling Date

The formula was:

IF(End_Date__c<=TODAY() +365, 1, 0)

In English, if the End Date of our opportunity is greater than or equal to Today's date plus 365 (days), return 1 if true, and 0 if false.

THEN: when creating the report I just filter by the names of the folks I want to include and Rolling Date equals 1.

The formula won't work for Text, it has to be Number. 

It works great, and I assume that by changing the + 365 to a - 365 it will create a TTM report. 

I can't believe that there's no Next 365 or Last 365 in the drop-down for report duration.