I have a data table where I am wanting to calculate mean, and have the output sorted (Descending) from a grouped column.
As an example
I.e., Data table
![justvince_0-1641851082378.png justvince_0-1641851082378.png](https://community.jmp.com/t5/image/serverpage/image-id/38886i864C2A7CDE0D4FF0/image-size/medium?v=v2&px=400)
If I summarize as follows:
Data Table( "Example_DT" ) << Summary(
Group( :i, :f, :g, :h ),
Order( Descending, Descending, Descending, Descending ),
Mean( :Values ),
Freq( "None" ),
Weight( "None" )
);
i.e., Selecting Descending
![justvince_3-1641852202649.png justvince_3-1641852202649.png](https://community.jmp.com/t5/image/serverpage/image-id/38889iE16B20DD7D74437B/image-size/medium?v=v2&px=400)
Output is incorrect: Shouldn't Column "i" start with 4 and descend down to 1? (This is the problem I am having with my large data table)
![justvince_1-1641851257020.png justvince_1-1641851257020.png](https://community.jmp.com/t5/image/serverpage/image-id/38887i0FD5D5B7A130A1E9/image-size/medium?v=v2&px=400)
If I try to sort by saying I want column i in ascending order it produces the same table
Data Table( "Example_DT" ) << Summary(
Group( :i, :f, :g, :h ),
Order( Ascending, Ascending, Ascending, Ascending ),
Mean( :Values ),
Freq( "None" ),
Weight( "None" )
);
![justvince_2-1641851482920.png justvince_2-1641851482920.png](https://community.jmp.com/t5/image/serverpage/image-id/38888i979DF7CFA5C95743/image-size/medium?v=v2&px=400)
I am using JMP 16.2.0