Sales Report

[AnthonyDixon]

I'm trying to create a top two sales report by customer sorted by highest sales first.

I have created a sub-summary report based on customer, but I guess I need to find my

top two before I run my report not sure how to constrain the set to only the top two.

A little lost :-(

Running v10 Advanced Mac/Win

Thank you in advance for any thoughts.

Anthony

Sales Report.fp7.zip

[comment]

Try it this way:

Sales Report2.zip

Note that this is just a rough sketch - it needs error trapping. See:

http://fmforums.com/forum/topic/69793-limiting-find-to-first-5-records/

[AnthonyDixon]

Try it this way:

Sales Report2.zip

Note that this just a rough sketch - it needs error trapping. See:

http://fmforums.com/forum/topic/69793-limiting-find-to-first-5-records/

WOW! Amazing! Worked perfectly.

Thank you so much!

Anthony