Another pivot table question!

N

Neil G

In my pivot table, I have rows showing scores for competitors over several
years

Some years they didn' compete, and hence the cell for that year is blank.

I would like to add a column/field that shows the number of years they
competed (IE a count of actual cells that contain a number.

Is this possible, is it a calculated field?

Thanks again
Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Weighted ranking of a series 3
Additional columns for Pivot table 0
Slicers and Calculated Items in Pivot Table 2
Average of % in pivot table 1
pivot table missing rows? 0
Pivot table question 1
Pivot Table Hide Selected Field 2007 0

Top