Comparing the sales line item of a similar kind of product

saibandaru

I have a list of products and few of those products are new to the hierarchy with no history. In this case i need to compare and refer from SALES line item' of a different product from same list. 

 

• I have only 1 product hierarchy list to use and it has associated sales, cost, profits,etc with it.
• Few Product has similar names(ex: Manchester jersey, Madrid Jersey, etc)
• I can compare using NAMES and lookup at their sales

                            or 

• I can also compare SALES with other products and refer to that respective SALES line item.
• I tried to use lookup function and use a condition but it did not work

 

What formulas can i use here to refer to Sales of other products in the same hierarchy and at same level of hierarchy??

 

 

Thank you!

saibandaru

Thanks for your view Paul. 

 

 

There is no problem in adding the product to the respective hierarchy/list. I dont get what formulas to use in the module so as to map one product data with another product within the same hierarchy and same level.