Excel 2007 pivot table-- can you show format a field for no calculations in the "Sum values" drag box?

I'd like to show values in a pivot table column that are not calculated.  However, when I drag this field into the "Sum values" box, I do not see any options except for calculated options.  I'd like to just show text.

Thanks for any suggestions you can offer!
BBRRGGAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MadonnaCCommented:
I would try Max or Min - the only time you may see unexpected results would be when there are actually 2 or more possible values for a cell
0
BBRRGGAuthor Commented:
Hmmm, still getting 0s when I do max or min...
0
telyni19Commented:
Can you give any examples of the values you are trying to show?

Generally in a pivot table, you'll put textual values as categories along either the column or row headers, and then put numerical or grouped and counted values in the central values area to be counted or summed. Based on what you've said, you could try putting your data in the row header area instead, and remove subtotals. If you've only got one value per category, then you should get what you're asking for.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Richard DanekeTrainerCommented:
Could you possible use that field as an additonal ROW or COLUMN value?   Data values are expected to be counts or other domain aggregate functions.  
0
MadonnaCCommented:
Put all the values you want as text in the Rows box
In the Field Settings, set the SubTotals and Filters to None
Set Layout & Print to Show Item Labels in tabular form

See attached spreadsheet for an example
PivotTest.xlsx
0
BBRRGGAuthor Commented:
Thanks for all's input.

MadonnaC-- this is certainly a great way to do what you're showing.  However, what I need to do is show these text records not as row labels but rather as values in 1 particular field, where other fields are in fact calculated.  It would look something like the following, where "additional notes" is the field I need to include from the raw data table.  Currently, when I try to add "additional notes," the program wants me to calculate the field.

             SumOf Days   CountOf Holidays     additional notes
Jan          31                             2                   mom's birthday
Feb          28                             0                   trip to Florida
March      31                             0                   basketball tournament
April         30                             0                   Taxes


Sounds like this may not be possible... I'll give it another day or so and then will close out the question... unless anyone has any further thoughts / suggestions.  Thanks!
0
telyni19Commented:
It looks like you're doing a pivot table on data where you have one line for each day. The problem is that when you summarize by month, the "additional notes" are not connected to the month, but to the day. If you want the notes to be effective for the whole month, you'll have to organize the data differently. To give you a comparison, what would happen, in your current setup, if you have notes for more than one day? Would you want them combined into one text field to show for the month? It isn't clear to Excel what would happen; there's no "concatenate" summary function for text fields (although that would certainly be useful in situations like this).

If you do what I suggested before and put the Notes field as a row header, you'll get a table that looks like the attached, where you have the data summarized by each note (I've included a second March note to illustrate) plus the blanks. With the subtotals, you get the details by note as well as the totals for each month. I think this is the closest you can get to your example table with an Excel pivot table.

If you used Access, you could have two tables, one for date (which includes holidays) and one for month (which includes monthly notes), and combine the two in one query which could produce exactly what you gave. But the notes would not be tied to a particular day in that case, so you'd lose the meaning of which day is "mom's birthday" for instance.
monthly-notes.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BBRRGGAuthor Commented:
Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.