Posted to microsoft.public.excel.programming

blackpuppy[_2_] blackpuppy[_2_] is offline

external usenet poster

Posts: 8

PivotTable: possible to display Data Item field as it is?

I have two Data Item fields. One is numeric and the other is text. For
the numeric field, I want to use the sum summarization function. But
for the text field, I just want to display it as it is.

Is it possible to display the data item field as it is instead of using
any summarization function?

Thanks!
blackpuppy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivottable Calc. Avg. field based upon monthly data	prebang	Excel Discussion (Misc queries)	1	September 16th 07 05:08 PM
PivotTable - summing more than one data field	Kruti	Excel Discussion (Misc queries)	4	July 27th 06 12:40 AM
function to reference all of pivottable data field array	andrew	Excel Worksheet Functions	0	February 22nd 06 05:54 PM
Pivottable data field	nc	Excel Discussion (Misc queries)	0	September 30th 05 12:44 PM
PivotTable controlled by more than one page field item	Dan	Excel Programming	0	September 30th 05 03:40 AM

All times are GMT +1. The time now is 10:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us