sort rows of a pivot table by a value of a specific column

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

sort rows of a pivot table by a value of a specific column

Max Bell-2
Dear listers

I need the rows of a pivot table to be sorted (descending) by the values
of a specific column. Is there a script or another solution for this?

Thanks, Max Bell
Reply | Threaded
Open this post in threaded view
|

Re: sort rows of a pivot table by a value of a specific column

Beadle, ViAnn
Two procedures that allow you to specify a sort order are TABLES and CTABLES. Other possibilities here are Sax Basic scripts; and xsl scripting on the xml written with OMS.

Could you be more specific about which output you want sorted.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Max Bell
Sent: Thursday, April 19, 2007 9:02 AM
To: [hidden email]
Subject: sort rows of a pivot table by a value of a specific column

Dear listers

I need the rows of a pivot table to be sorted (descending) by the values
of a specific column. Is there a script or another solution for this?

Thanks, Max Bell