Skip to Content
0

Group Sort Expert

Oct 27, 2017 at 05:16 PM

17

avatar image
Former Member

Hi,

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!!!

Thanks,

Mark

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers