I have I am trying to be able to create a tabular table where I can sort the values by the statistic, such as mean value. So for example, for the sample file "Car Poll", I have the following basic tabulate code:
Column Table( Analysis Columns( :age ), Statistics( Mean ) ),
Row Table( Grouping Columns( :size ) )
Which produces the following pivot table:
but I would like to be able to sort the means in descending value so the first row shows "Medium " and it's values, 2nd row as "Large", and 3rd row as "Small". I know there is a
Sort(By()) function for data tables, but there doesn't seem to be anything similar for tabulate. Does anyone have a suggestion of how I could achieve this?