I've created a store P+L consisting of sales, cogs, gross margin, occupancy cost, payroll cost, and advertising cost. These all drill down to contribution margin (basically the stores EBITDA). I was wondering if there is any way to make the table I have created dynamic so that when I create a parameter to increase sales, the other metrics change accordingly. Thanks for the help!
This can be done. A calculated field using the parameter will need to be created for each measure and then placed on the view.