Click to See Complete Forum and Search --> : Sum the Top N Values


ahightower
June 13th, 2008, 10:50 AM
I am creating a report that i want to show the Top 5 Customers Margins, but then I want to add those values and only those values together. I have used the Top N formula but when I try to sum it give me the sum of everything. Help! Thanks

jawadhashmi
June 26th, 2008, 12:12 AM
You can do it manually.

First Sort the records according to your choice.

Keep the track of the no of the records

and sum them up for the number of records you want.