Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sorting based on Formula results

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

Former Member
Former Member replied

Hey Holly,

Just put your query in the "Command" table.

Database Expert >Current Connections > Add Command

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question