Excel pivot table - how to sort strings as numbers
Solution 1:
the pivot tables in Excel are very underwhelmingly underpowered. I would recommend creating an new row in your data table and convert the strings to numbers there then use that new row in the pivot table.