Sort rows in a cross table by a measure

Achraf_Ougdal — Sun, 25 Jun 2023 09:42:36 GMT

Hello,

I have a simple and quick question,

I have a cross table with Category/Product on lines and Years on columns and a measure. Can I sort each Product in each category by measure ? In other words for each Category, i want to sort the products by measure. also, can I sort by a measure that is not displayed in the cross table but available in the data panel.

Thank you

Re: Sort rows in a cross table by a measure

Madelyn_SAS — Mon, 26 Jun 2023 19:20:47 GMT

If you right click a measure value, you should see the option to apply a sort to each of the categories used in the crosstab.

You cannot sort on a measure that is not in the table.

topic Sort rows in a cross table by a measure in SAS Visual Analytics

Sort rows in a cross table by a measure

Re: Sort rows in a cross table by a measure