Top N Values - Multiple Worksheets



I am not having much luck with this:

I am trying to return the top N purchases based on a client ID.

Sheet 1: Account Summary

Sheet 2: Master_Territory contains table Master_Table (Customer #, Name, etc)

Sheet 3: Client_Purchases contains table cPurch (Customer #, Customer_Name, Line_Name, Line Code, Net Sales)

Sheet 1 to display based on Customer Number selected on Account Summary:



Net Sales



This is too much like work and too little like Q&A. Find one explicity question you would like to have answered and indicate the source of referenced data in your question rather than in some probably faulty formula hidden in a worksheet.
Variatus (rep: 2938) Feb 8, '19 at 8:04 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login