multiple count Pivot table in Excel
Posted
by
Sivakanesh
on Super User
See other posts from Super User
or by Sivakanesh
Published on 2011-02-01T14:16:08Z
Indexed on
2011/02/01
15:28 UTC
Read the original article
Hit count: 303
excel
|pivot-table
Hi all, I'm trying to put togeter a pivot table from an Excel spreadsheet. The spreadsheets look similar to the following:
DeptHead, Emp, Increment
x, A, 2.5%
x, B,
y, C, 1.5%
y, D,
y, E, 2.0%
I would like to make a pivot table that looks like the following;
DeptHead, CountOfEmp, CountOfIncrement
x, 2, 1
y, 3, 2
So it provides a count of total number of Emps and total number Increments for each DeptHead ignoring the blanks. I have tried to do this in many ways in Pivot table, but the two counts are only appearing in rows and not in columns as above.
Is there any way to achieve this please? Thanks
© Super User or respective owner