I created a parameter slider based on percentages which can show the difference if costs were saved (or gone down) by 5%, 15%, etc. I am now building a chart and graph to visually show the difference between the total amount spent (which should be a fixed value) and the new amount spent based on the percentage saved. The problem is that when I use the slider, not only does the percent saved values change, but also the total amount spent! Is there a way for me to ensure that the total amount spent stays constant? I also have both totals stratified by a dimension, I am not sure if that may be influencing the values or not...?
Hi Meko, can you share a packaged workbook for us to see?