We'd like to be able to create a formula in a Account Schedule to build TTM (Trailing Twelve Months) and Prior TTM (TTM from one year ago).

Trailing Twelve Months would be the revenue of the 12 months leading up to the current month (TTM = [April 22] + [March 22] + [Feb 22] + [Jan 22] + [Dec 21] + [Nov 21] + [Oct 21] + [Sept 21] + [Aug 21] + [Jul 21] + [Jun 21] + [May 21])

We'd like to be able to feed this into a dashboard, but the formulars available don't allow that.