Hello,
I am preparing input metrics to be filled in by the sales reps for the forecast.
In the process they must allocate the “Fit Option” based on percentages by Model.
However, for the model “A4”, “B4” and “C4” they can only fill in the “Fit option” “A “or “B” and for Model “D4” and “E4” it is always “3”.
So, I was wondering if there is a way to:
- Only show A and B for Model A4, B4 and C4 and 3 for D4 and E4?
- Can I automatically fill in 100% for model D4 and E4 option “3”?
- Is there a way to highlight that each subtotal by model should be equal to 100%?
Thanks for your help!
Ben
