Display selected item from a list for input and calculations

Roelofg

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

 

 

 

 

LipChean_Soh

Hi,

 

I would encourage you to do the following:

 

However if you're keen with the 'Rep_Customer_Product' list, i would ask why you have the 'Rep' by 'Customer' by 'Product' by 'Time' module? Why not just create a 'Rep_Customer_Product' by 'Time' module? 

 

Having said that, you can still achieve what you wanted by creating the 2 line items below:

1. Concatenated Name = NAME(REP) & "_" & NAME(CUSTOMER) & "-" & NAME(PRODUCT)

2. Active? = ISNOTBLANK(FINDITEM(Rep_Customer_Product,Concatenated Name))

 

Finally create a Filter by referring to 'Active?'

 

Thanks,

LipChean