I have a report where I have running sums in the group footers. I am
storing sales information at the customer level with information
month, year, sales, and cost as columns in that data record. In my
report I want to show year to date sales, last year to date sales, and
the variance between both. Everything looks great, but now our
company wants to show the 20 worst performing accounts in each region.
Is there a way that I can sort on the variance or delta of those
fields ascending manner? I cannot figure this out. Any help would be
appreciated. Thanks.