Display selected item from a list for input and calculations
I developed an module displaying Rep, Customer and product.
This required to enable planning to be done at Rep Level, Customer and Product levels. This will be used to input unit volumes per product / customer and Rep
The easy way would be to have the total product list but each Rep are responsible for selected product and of course the customers has their preference as well.
For that i developed a matrix depicting those relationships.
Now the problem statement:
Referencing to the picture below where i use the Rep, product and customer lists resulting in this comprehensive module. How can i limit the view in alignment with the requirements above