You can clone the report and adjust the SQL query to not display "version" and this will bring merge the counts to the display name.
Remember that CMPivot is more about real-time data.
if you are looking for a book to help you with creating queries for ConfigMgr you can try. It will also show you about how to create reports too. https://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780134466811