Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2010 Pivot Table
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2010 Pivot Table
On Tuesday, July 10, 2012 11:40:21 AM UTC-4, carl wrote:
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2010 Pivot Table
On Tuesday, July 10, 2012 11:40:21 AM UTC-4, carl wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2010 to auto-generate an email to recipients in outlook 2010 | Excel Programming | |||
Pivot Table Excel 2010 | Excel Programming | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming |