| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to DISPLAY all data values in Pivot Table...not count, sum, etc
I have a list APPLICATIONS used by our different DEPARTMENTS by REGION eg DEPARTMENT REGION APPLICATION Accounting Europe MS Word Accounting Asia Word Perfect Marketing NorthAm Word Perfect What I'd like to do is create a table that shows DEPARTMENTS in Rows and REGIONS as columns. Then in the data area i just want to display all the APPLICATIONS (ie no sum, count, avg....just list all the systems that match the Department/Region combination Any Ideas? Are there any addins that could help? eg NORTH AMERICA EUROPE ASIA <etc... Accounting | MS word MS word word perfect | outlook ccmail outlook ---------------------------------------------------------------------- Marketing | Word Perfect Word Perfect Word Perfect --------------------------------------------------------------------- Development | Excel Lotus Lotus | Outlook Outlook ccmail | ----------------------------------------------------------------------- <etc.. | -- spot1234 ------------------------------------------------------------------------ spot1234's Profile: http://www.excelforum.com/member.php...o&userid=36632 View this thread: http://www.excelforum.com/showthread...hreadid=563817 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function? | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
| Pivot table Data always showing up as "Count" | Excel Discussion (Misc queries) | |||
Threaded Mode
