Thanks @movak for the report, we'll investigate this

I tried to reproduce with latest Piwik version and seems to work for me. Which Piwik version are you using? Can you maybe post a screenshot?

Yep, here's my screenshot:

What's your Piwik version?

Just switched to EUR and works for me as well (just in case sort was applied after formatting the metric), I see there are comma values, maybe the problem is related to locale. Will try

Still cannot reproduce it :( Maybe let us know a bit more about your environment, eg Piwik version and PHP version. Does it work for other columns?

Ops sry I forgot:

Piwik 2.14.3
PHP 5.4.41-0+deb7u1

The sorting of this column doesn't work in the SKU and Product Category reports. All other columns seem to work fine.

Can maybe someone else try to reproduce on another instance?

I played a little bit with the date ranges and noticed something interesting: The sorting does not work only if data before the 7.8. is included. Now unfortunately I don't know if there are any problems between the 3th to the 5th as the item prices were all 0. But if I choose only the 6th, when items started to have prices > 0 it doesn't work. So I assume it has something to do with the items that were tracked on the sixth... I can also give you Piwik access for this test site if that helps.

I know this is an old issue, but we just started tracking with Matomo last week, and for most days we have the same problem - the sorting by product revenue instead sorts by visitor number. It gets worse when we select any segment, then it even won't work for the "good" days... Currency is EUR.
Matomo-Version: 3.14.1
MySQL-Version: 10.1.45-MariaDB-0+deb9u1
PHP-Version: 7.4.10

closing in favor of #21829