New Contributor

## Inputting product mix % via a dashboard

I have a mix of products which must always total 100%. When forecasting, I would like the ability for the user to either a) type in the product % mix, or b) increase one whilst simultaneously decreasing another (of their choosing) via a dashboard. If possible, could anyone help with how to set up point b?

1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Here is a way you can do it based on holding certain values constant and overriding others. In this example the East region is held constant, the South region is overridden, and the Central and West regions are allocated the remaining amount of the total initial target based on a percentage of their values to the total region. Therefore, your initial target total for USA is the same as the total for the region target. I'm assuming you could recreate this same functionality utilizing percentages instead of dollars.

You could also try and utilize the breakback functionality but that doesn't work for percentages.

5 REPLIES 5
Certified Master Anaplanner

@JenniferMontgomery  Certainly possible! The setup will of course depend on the specifics of your requirements.

If it is a one to one relationship, you can create a line item when the user inputs the "offset product" and then use the SUM function to aggregate the offset amounts.  You would then create a forecast line item that takes into account the Product Mix Inputs as well as the increase + offset amounts.  Below is a simple example of how you might set this up.

Community Boss

I assumed your scenario in a following way.

Let me know if this addresses your problem, else please explain in much more detailed way and if possible share screen shots.

Thanks,

Sorna Raja Prabhu

Sorna Raja Prabhu
Contributor

Here is a way you can do it based on holding certain values constant and overriding others. In this example the East region is held constant, the South region is overridden, and the Central and West regions are allocated the remaining amount of the total initial target based on a percentage of their values to the total region. Therefore, your initial target total for USA is the same as the total for the region target. I'm assuming you could recreate this same functionality utilizing percentages instead of dollars.

You could also try and utilize the breakback functionality but that doesn't work for percentages.

Master Anaplanner/Community Boss

I prefer the solution provided by @smithevan18It is also a commonly used approach in Anaplan. If you download the FP&A for SaaS model, you will see the implementation of this method and you can study it and replicate it in your model

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
New Contributor
Thank you, this is most helpful!