ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/249754-pivot-table.html)

Connie Martin

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


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com