Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table data field | Excel Discussion (Misc queries) | |||
use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
Pivot Table Field Data | Excel Worksheet Functions | |||
Pivot Table Data Field Query | Excel Worksheet Functions |