Hello there,
I only recently found out about the pivot capabilities beside my 20 and some years experience with excel vba etc ..
I somehow cannot get the pivot i want.
This is the situation:
I have a table for work with 4 columns
Name, Certificate Name, Expiry Date and a column with a formula calculating the number of days expired
There is hundreds of certificates (with at least 25 different certificates) in the table so it would be nice if I could have the following pivot
- How many people obtained some certificate
- For each certificate how many expired (and how many are still valid)
The first is obvious and I got, the second I cannot find how ... does it have to do with the Value Field Settings ??
Any pointers would be great!
Thankx
I only recently found out about the pivot capabilities beside my 20 and some years experience with excel vba etc ..
I somehow cannot get the pivot i want.
This is the situation:
I have a table for work with 4 columns
Name, Certificate Name, Expiry Date and a column with a formula calculating the number of days expired
There is hundreds of certificates (with at least 25 different certificates) in the table so it would be nice if I could have the following pivot
- How many people obtained some certificate
- For each certificate how many expired (and how many are still valid)
The first is obvious and I got, the second I cannot find how ... does it have to do with the Value Field Settings ??
Any pointers would be great!
Thankx