Bring a value based on summary method
I am trying to create a line item where I specify which product was sold the most by each of my sales reps.
Rep and Product are lists on my model.
I have a module called "Sales history" where I have the sales of each rep for each product.
I want to have a module where I can select a rep and the line item (let's call it "Most sold") shows which product the rep sold the most.
Can you help me?