3 Replies Latest reply: Nov 28, 2012 3:40 PM by Rebecca Molstad RSS

    Is it possible to create a What-If table or chart and have the slider or variable field impact only a specific record within a dimension, but not the entire dimension...

      An example of what I am trying to do is allow the user to move a slider which would impact cost or revenue and the output would be changes in margin %. The dimension is Product Group. Right now, all of the product groups (about 10 of them) are impacted from the one variable. 

       

      Does anyone know how (and if) I would be able to allow a slider (variable) to impact a specific product group instead of the entire dimension. For example, a 5% increase in cost and a 4% increase on product group B would change the total gross margin % by X%; as opposed a 5% increase in cost and a 4% increase in price across the board. I want to minimize the need for the user to have to make selections from list boxes and export the data to do additional calculations. I'm not very experienced with scripting or data models, but have been designing mostly from the user interface properties.