Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables are showing One's where real value should be
I have three columns.
A - Variant B - Feature C - Option You will have one variant (unique) on the left side; features across the top and options in the middle as content. There are multiple features and options, but an equal amount. My data just shows 1's in the middle as content and not the value of the option -- does anyone know why? A B C cpva feature option 488761 upholclr 61201833 488761 fdnprc fdnprc9 488761 rearmt - 488761 pkg std |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables are showing One's where real value should be
pivot tables have numeric output, they won't put out text
if I am reading your table correctly "Rookie_User" wrote: I have three columns. A - Variant B - Feature C - Option You will have one variant (unique) on the left side; features across the top and options in the middle as content. There are multiple features and options, but an equal amount. My data just shows 1's in the middle as content and not the value of the option -- does anyone know why? A B C cpva feature option 488761 upholclr 61201833 488761 fdnprc fdnprc9 488761 rearmt - 488761 pkg std |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables are showing One's where real value should be
WOW, that's a major blow. Thanks for helping though. I guess I can resort
back to ACcess in a cross tab query. If there is any way to get non-numeric output please let me know. "bj" wrote: pivot tables have numeric output, they won't put out text if I am reading your table correctly "Rookie_User" wrote: I have three columns. A - Variant B - Feature C - Option You will have one variant (unique) on the left side; features across the top and options in the middle as content. There are multiple features and options, but an equal amount. My data just shows 1's in the middle as content and not the value of the option -- does anyone know why? A B C cpva feature option 488761 upholclr 61201833 488761 fdnprc fdnprc9 488761 rearmt - 488761 pkg std |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables are showing One's where real value should be
Hi
As you have been told, you only have numeric values in the data area. However, try dragging Variant to the row area, followed by Feature, followed by Option and add Count of feature to the data area. Double click on VariantSubtotalsNone Double click on FeatureSubtotalNone Hide Column D Not exactly the layout you wanted, but it may suffice. -- Regards Roger Govier "Rookie_User" wrote in message ... WOW, that's a major blow. Thanks for helping though. I guess I can resort back to ACcess in a cross tab query. If there is any way to get non-numeric output please let me know. "bj" wrote: pivot tables have numeric output, they won't put out text if I am reading your table correctly "Rookie_User" wrote: I have three columns. A - Variant B - Feature C - Option You will have one variant (unique) on the left side; features across the top and options in the middle as content. There are multiple features and options, but an equal amount. My data just shows 1's in the middle as content and not the value of the option -- does anyone know why? A B C cpva feature option 488761 upholclr 61201833 488761 fdnprc fdnprc9 488761 rearmt - 488761 pkg std |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot Tables - Showing Details for some fields, but just summaries for others | Excel Worksheet Functions | |||
Showing my coworkers how to work with Pivot Tables | Excel Discussion (Misc queries) | |||
Fill color not showing up on cell tables | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |