Hi Sam and Forum Friends
Here is a Challenging Scenario i am looking for a solution:
- I have 5 Products
- Each Product requires a Demand; Cost; Profits and Margins to be Calculated by changing Demand; Cost; and Price Variables using Slicers
- Management wants to play with Each Product Scenario Individually to see Outcomes of Variable Manipulation
- Hence Each Product Scenario is on a Single Page
- Now Management wants to see Combined Output of All the Products on a Single Page while at the Same Time Playing Individually with Each Product.
- Have created Single Page for each Product to change Demand; Price; Cost Values using Slicers to calculate Profits; Total Revenue and Margins
How do i create a Combined Single View of Total Revenues; Total Profits and Total Margins on a New Page by taking Values from each page and New Page is Dynamic to show change in Values of each Page?