Sort by Count in SQ01

[Former Member]

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

[Former Member]

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.

[Former Member]

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]

Hi George,

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

Regards,

Stephen