Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Sort by Count in SQ01

Former Member
0 Kudos

Hi Guru's First time posting so be gentle !!

In SQ01 does anyone know how to sort by the count or is there a formula which can be used in a complex calculation to return a number of records which has been repeated.

for example the number of times a material appears in a storage type sorted in descending order by the count of the material.

Thank you for your time to look.

Edited by: GTHURK on Jul 12, 2010 5:57 PM

Edited by: GTHURK on Jul 12, 2010 5:58 PM

3 REPLIES 3

Former Member
0 Kudos

Yes it is possible, Play with the options in "Statistics" or "Ranked List" instead of the "Basic List" while creating the query to sort, count or generate subtotals.

0 Kudos

Ramesh it is not clear as to which of the options gives a count which can be sorted in descending order by column

Former Member
0 Kudos

Hi George,

Did you ever find a solution to this?  I appreciate it was a long time ago.

Regards,

Stephen