Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello. I have a pivot table that looks like
Client Name Div 1 Sales Div 2 Sales Div 3 Sales Div 4 Sales One Corp 100 200 250 65 XYZ Corp 155 100 Smith & Jones 50 20 75 What I want is to add the Count of Divsions like this Client Name Divs Div 1 Sales Div 2 Sales Div 3 Sales Div 4 Sales One Corp 4 100 200 250 65 XYZ Corp 2 155 100 Smith & Jones 3 50 20 75 Is there a way I can do this in a single pivot table or by combining two pivot tables? Thanks, JohnV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function? | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table Data always showing up as "Count" | Excel Discussion (Misc queries) |