Forum Discussion

Cali_2020's avatar
Cali_2020
Icon for Helper I rankHelper I
6 years ago

Budget vs. Forecast - dynamically chaning figures based on version

Hello! I need the community’s help to create a dynamic matrix table based on three separate timestamp “versions”: budget, forecast, and previous forecast. The way I’d like to set it up as that I want 10 different matrix tables on the page based on different business units but these business units will remain static. Then I would like 4 slicers on the page that will dynamically change the figures on the ten tables: fiscal year, fiscal quarter, current forecast version, and previous forecast version. On the rows, I need to show specific metrics that are calculated based on measures (revenues, costs, costs(%)/revenues, install base, costs / install base, repair volumes, repair volumes(%)/install base, etc . On the columns, I would like to show in the following order: budget, forecast, forecast/budget (based on a measure), and forecast/previous forecast (based on another measure). I have searched the forums looking for a solution but haven’t found anything. Does anyone know how to develop the model to create this kind of matrix based on these measures? Any suggestions and advice is greatly appreciated! Thank you!