Scenario Planning.


Hi, I need some help in building a scenario model. For example, In the P&L report, there are 2 scenarios the user can switch. In what-if scenario 1 user can update the Unit price/Unit cost and the changes will reflect in Revenue and COGS. And in what if Scenario 2 User gets to change the volume and changes reflects in Rev and cogs. Help me with the steps to follow and build a scenario model.


  • You can use versions dimension for the use case.

  • Creating a scenario model involves building different versions of a financial forecast based on different assumptions. In your case, you want to create two scenarios in a P&L report: one where the user can update the unit price/unit cost, and another where the user can change the volume.