Sorting a pivot table A-Z keeps giving me
Bad Debt
Bank Charges
Depreciation
Dues & Fees
Tax-Real Estate
Advertising
Employee Benefits
Insurance
Everything after Insurance is sorting properly. If I copy and paste the values outside of the pivot table and sort A-Z it sorts correctly. Any idea what could cause a pivot table to do this?
Bad Debt
Bank Charges
Depreciation
Dues & Fees
Tax-Real Estate
Advertising
Employee Benefits
Insurance
Everything after Insurance is sorting properly. If I copy and paste the values outside of the pivot table and sort A-Z it sorts correctly. Any idea what could cause a pivot table to do this?