Skip to Content
avatar image
Former Member

Group Sort Expert


I am trying to do a TOP 20 Dollars based off of all invoices by Vendor. Then, in the report, I want, by record, the % of the Total Dollars, and also, the % of the Top 20 Dollars. I am able to get the Total Dollars, but am having a HUGE issue of getting the Total Top 20 Dollars by record for the formula. I am getting a sum by record for this column. It looks like Crystal creates a sub report for the TOP 20 Group Sort, then grabs this data and only puts the TOP 20 dollars by Vendor in the report. If I run the query and sum on Dollars, I am forced to group on all of the other columns which will not bring in the results that I am looking for. Any help would be great!!!



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers