Sorting based on Formula results
I have built a report that is constructed like this
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
Just put your query in the "Command" table.
Database Expert >Current Connections > Add Command