Pivot Table Cell Formatting

J

Jim G.

A pivot table "seems" to want to define all the cells within the table as numbers. Several columns of data within my source data are character (i.e. Y/N). The pivot table displays all Y and N's as a 1 when the cell is defined as a count. If you change to a sum or any other "available" types, they display as 0's.

I can't seem to get around this. I want the Y or N value displayed. Any ideas or suggestions.

Thanks, Jim G.
 
F

Frank Kabel

Hi Jim
the data section of a pivot table can (AFAIK) only consist of
(aggregated) values. That is counts, sums, averages, etc. You're not
able to display text in this section.
Maybe you can explain what you're trying to achieve so that we can give
you a solution for your issue
 
J

Jim G.

Thanks for your input Frank. I am simply taking a oracle query result and attempting to create a report that must "pivot" the rows and columns for final reporting. A few of the fields that I need to report on are "Y"es / "N"o fields that must be pivoted with the rest of the data. As I described in my original email, the pivot report wants to resolve these fields as 1's or 0's based on the format (i.e. sum, count etc..)

It appears by your response and my extensive research into the pivot table capabilities, that i will not be able to "automatically" resolve this problem. I've already thought of and tested copying the pivot table data and pasting "special" the values where I may "manually" change the values from 1 to "Y"

Anyway, thanks for your time and if you have any other suggestions, I would warmly welcome them

Jim G.
 
F

Frank Kabel

Hi Jim
could you post some sample rows of your source data and some sample
rows of your espected pivot table (plain text please). Otherwise
difficult to say what you can do
 
Top