This idea has been merged into another idea. To comment or vote on this idea, please visit APP-I-1758 Allow Sorting Rows/Columns in the Pivot Table.
I can create a pivot table that totals the number of ideas submitted per user, but sorting appears to be handled alphabetically even if you change the report to list a numerical count (as opposed to text names).
This really is basic.