I have a table like this:

Type Number
AA 1
aa 2
Aa 3
aA 4


When I use the Pivot wizard i get this result:

Sum of Number
Type Total
AA 10
Grand Total 10


Is there a setting that will enable the Pivot to recognize the upper and
lower case types as unique ?

Thank you in advance.