Deferred Payments

[Catafin84]

Hi

I am trying to create a formula which will give me the following result:-
Total revenue of orders placed in a certain month, and in what month that revenue will be recognised.

For instance, orders placed in January, may have the revenue deferred until Feb, and so on.

Order Order Month will <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Month Value recognise revenue<o></o>
Jan £5,000 Feb<o></o>
Feb £5,000 Mar<o></o>
Mar £5,000 Apr

These are the columns with the relevant information, but im stuck as to what order they need to go in!

Order Value = Column P<o></o>
Order Month = Column T<o></o>
Deferred Month = Column Y<o></o>
Is the revenue deferred = Column R<o></o>


Thanks to anyone who can make sense of this!

<o></o>
<o></o>

 

[Oaktree]

Sounds like a job for a pivot table.

If you put order months as rows, month recognized as columns, and order value as the data, you'd get a clean crosstab of the flow.