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

Selecting Date Range in a Pivot using VBA 0
Pivot table using External data 3
Pivot table hidding zeros in sum of amount 0
Changing pivot table ADO recordset 0
Using VBA on Excel Pivot Tables 3
Pivot Table Data Aggregation 0
Pivot Table Data - Troubleshoot needed 1
Pivot Table Counting Text Data 0

Top