Trailing spaces in Pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know why 'abc' and 'abc ' appear as two different values in
pivot table page, row, or column fields? Is there a configuration setting to
control this? The same values appear only once in the filter list in a
filtered data table, and behave per ANSI 92 (ie 'abc'='abc ') in Microsoft
query group and criteria statements.
thanks in advance
Baffled in Bury
 
to the best of my knowledge, there isn't. Pivot Tables are not using SQL to
the best of my knowledge. In a cell, your example is false.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel pivot fields and trailing spaces 1
Pivot Table Question 2
Excel problem with trailing spaces 1
Pivot table refresh problem 2
Totaling columns in a row with duplicate data - Pivot Table?? 1
display all row fields in pivot table 1
Pivot Table Calculations 2
pivot table not getting updated 2

Back
Top