| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
In my raw data sheet I have a list of customers, and in column G it either
says "2 WKS" or nothing. In column H it either says "3 WKS" or nothing. I've done a pivot table with the Customer in the row section, columns G and H in the Data part as "count" being the function. What I want it to do is count the number of times "2 WKS" shows up for a customer and the number of times "3 WKS" shows up for a customer, but instead it's giving me the total number of times the customer is in the spreadsheet. How can I correct this? Connie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
