Do you mean that a report would like this for an individual customer
Jan 2024 $150K
Variance $50K
Feb 2024 $200K
Variance ($25K)
Mar 2024 $175K
In between each month is the amount to get you to the next month?
If that is true, Quickbase cannot format data that way. If this is C-Level request and it must be like that, you need a different reporting tool like Tableau or PowerBI
If this format is acceptable
Jan 2024 $150K Variance $50K
Feb 2024 $200K Variance ($25K)
Mar 2024 $175K
In this case the Variance field is a formula field in each record. There is a couple ways to do this. A formula query can pull the information from a later record down to the earlier record. I would use a Pipeline instead that runs once a month to take this month's revenue, crystalize that value and then also write it to the previous month to then calculate the variance.