Excel 2010 Pivot Table

C

carl

I ran into an issue while using the Pivot Table.

My data looks like this:

Code RejectReason
AP No Quote
AP No Quote
AP No Quote
AP No Quote
AP No Quote
ap No Quote
ap No Quote
ap No Quote
ap No Quote


But the Pivot Table creates this:

Row Labels Count of RejectReason
AP 9
Grand Total 9

So it appears as if the Pivot does not recognize the difference
between AP and ap.

Is there a workaround for this ?

Thanks in advance.
 
C

cmiedaner

I ran into an issue while using the Pivot Table.

My data looks like this:

Code RejectReason
AP No Quote
AP No Quote
AP No Quote
AP No Quote
AP No Quote
ap No Quote
ap No Quote
ap No Quote
ap No Quote


But the Pivot Table creates this:

Row Labels Count of RejectReason
AP 9
Grand Total 9

So it appears as if the Pivot does not recognize the difference
between AP and ap.

Is there a workaround for this ?

Thanks in advance.
Click to expand...
 
C

cmiedaner

I ran into an issue while using the Pivot Table.

My data looks like this:

Code RejectReason
AP No Quote
AP No Quote
AP No Quote
AP No Quote
AP No Quote
ap No Quote
ap No Quote
ap No Quote
ap No Quote


But the Pivot Table creates this:

Row Labels Count of RejectReason
AP 9
Grand Total 9

So it appears as if the Pivot does not recognize the difference
between AP and ap.

Is there a workaround for this ?

Thanks in advance.
Click to expand...
 

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

Using VBA on Excel Pivot Tables 3
Average of Subtotals in Pivot Table 0
Get grand total from pivot table 2
Pivot table calculated field Count(field) / sum(field) 0
Corrupt files due to pivot remnants after saving via VBA 0
Question on the occupied field of the pivot table in excel spreadsheet 0
Summarsing Variable Pivot Table Data 1
Macro Debug on Pivot Table 5

Top