Sort rows in a cross table by a measure

[Achraf_Ougdal]

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

[Madelyn_SAS · Accepted solution]

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.