Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table to calc by group
I have a data set with a number of grouped items. Group A. Group B. Group
C. Etc. Each group has a number of series. Series 1. Series 2. Etc. Each Series of each Group has a Status. For simplicity, let's say Open & Closed. So the data is arranged by columns, each column representing a field, one for Group, Series, and Status each. So one record might be: Group A, Series 3, Status Closed. What I need is a count of the number of Groups that are open, the number that are closed, and the number that have more than one Series with differing Statuses. Anyone know a way to do this? I've been experimenting with using a Pivot table with limited luck (Pivot: Y axis = Group, X axis Status, Count Series, then function at bottom using COUNTA().) Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Group by Week? | New Users to Excel | |||
pivot table | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Pivot Table - no group on web | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |