My row data has numeric values as strings so of course it sorts as strings. How can I force it to sort as numbers? It seems I can't use a formula in the pivot table.
|
feedback
|
|
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. | ||||
|
feedback
|
|
One workaround might be to copy your pivot table and "paste special as values" to a new sheet. Then you can convert them to numbers or use formulas. | |||
|
feedback
|
