View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_2_] Fred Smith[_2_] is offline
external usenet poster
 
Posts: 1
Default Pivot Table Data Field Option

Thanks for your time.

My data is as follows:
Connection City Type
1 LA P
1 NY T
2 LA T
3 NY P
3 DC P
3 LA T

I have a standard Pivot Table with 1 heading on the left table and 1 heading
on the top. Nothing fancy. Here is the layout:

Count of Type City
Connection DC LA NY
1 1 1
2 1
3 1 1 1

What I'm looking to due is instead of showing "Count" of Type, I.E. the
number 1, I want it to give me the value (P or T) from the Type Column. Like
this:

Value of Type City
Connection DC LA NY
1 P T
2 T
3 P T P

Thanks again for your time.