Several problems in version 3.0.6.2

[AnSit]

1) An error when sorting report. If you select in the "Set Interval" value "Products" then sort by column "Total Items sold" gives unrealistic and incorrect data. You have to do a demo site sorting even did not work.
2) When viewing the "Inventor" no choice number of items on the page. I somehow displays to 29 of items. Version Joomla 3.4.0. Everywhere selected to show 100 items.

Please help us to understand and fix it.
Thanks!

[AnSit]

The problem 2) understood the reason. I have all 157 products of which 50 are published. So instead of having to show up on the first page of all 50 VMs paginated all 157 products without showing unpublished. So it turns that the first 100 shown only 29 published and the rest on the next page already. Uncomfortable and illogical way.