I'd like to be able to create a fairly simple scenario analysis where the user can enter a percentage into an input box and see the affect on sales.
Inputfield sort of gives me what I want, but I need to be able to makes changes at a higher level. For example, if Brand_A increases by 15% or ProductLine_W descreases by 5%, what will the total sales be? I need the 15% to affect all products under Brand_A without having to key several numbers in.
I updated your example, very basic but hopefully this will get you headed in the right direction! Just adjust the slider to effect the forecast numbers.
Thanks again, Leonard. And while that example does give me exactlywhat I asked for, I need to it on a much larger scale with hundreds ofbrands and product lines.
I thought about creating variables in my script foreach brand and product line but as far as I know, there's no way tosearch for a specific variable.
I want the user to beable to pick Brand_A from a list box and simply increase everythingunder that brand by 10 percent. Then pick Brand_D from a list box anddecrease everything for only that brand by 5 percent. Or do the same ifa product line needed to be changed.
I have an example of how I want it to be in the end, but I don't see how I can add an attachment to a reply. I had to key in the values that I wanted for each individual product in the tablebox. This is fine if there are only a few items,but I have thousands and I need a way to be able to select a group ofitems and adjust them.
