Skip to Content
0
Former Member
Sep 19, 2008 at 07:04 PM

Sorting based on Formula results

16 Views

I have built a report that is constructed like this

Main Report

Group one = Sales Agents Location

Group two = Sales Agents Names

Group two Footer A

I have subreport linked to the Sales Agents ID that totals their tours taken.

Group two Footer B

I have a subreport that is linked to the Sales Agents ID that totals their Sales Made

I have a formula that divides Tours by Sales to get their ratio.

I need to SORT each agent by highest ratio however my Group Expert is grayed out. Is their another method?

Edited by: Holly Elliott on Sep 19, 2008 9:07 PM