Pivot Tables Case Sensitive Grouping

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

Guest

Hi

I have a pivot table which is group items even if the text in the field is
not the same case - ie I have abc123 and ABC123 - The Pivot Table is grouping
it one the line rather than displaying two lines.

Anyone come across this before ??? I've looked for some options around this
but can't see to disable the case insensitive grouping.

Thanks
 
You could create a function that returns a unique value for each text string
and use that as the grouping column of the pivot table. Post back here if
you want such a function

Gerry
 
That's pretty much the way excel compares strings--it ignores case in most cases
<bg>.

Depending on what you're doing, you could use another column and include that in
your pivottable:

=if(exact(a2,upper(a2)),"Upper",if(exact(a2,lower(a2)),"Lower","Mixed"))

But 123-#*&^*% will be marked as Upper.
 
You can create a separate column in your data source and add the formula =A9&"_"&TEXT(CODE(A9). The results for a value of 'M' or 'm' in cell A9 will be be M_077 and m_109 respectively in the pivot table.
 
Back
Top