My data table has several columns with both numbers, displayed as %, and Text. The text is: N/A.
Please note, it is not #N/A, just simply N/A, and is text, not the result of a formula/function.
When I pivot out the data table, the N/A are being shown as a 0 and thus 0.00%.
I need to carry...