Hi
I am trying to build an interactive chart where a user there is a constant line (profit) and then a line based on a calcuated field (moving profit). Moving profit would be an equation like this (y=base profit + .5a+1000p+1000p), where a=advertising, p= PR, w=word of mouth. Users can enter the number of units of each advertising, PR, & word of mouth will be included in the model, and the line would update itself. The trick being that users can select the date and then pick volumes of each variable and the formula would only apply after the date of which user chooses. Any help would be GREATLY APPRECIATED.
Anna
I have found a way to make the variables adjust to one another based on a parameter, but is there a way to make it so the dates ONLY adjust via a selected reference date and going forward.