Calculated Field in Pivot Table minimum value

Jun 16, 2011
Reaction score
This is giving me a big headache!!!

I have a spreadsheet which I have put into a Pivot table.

The columns of data are:

Date (1 - 31st May)
Job type (can be the same type of job within the same date) (DE, RE, New, DE/RE)

Date across the top of the PT, and job type down column A.

I would like to count per job type per day per engineer, HOWEVER, for each job type per day I need to deduct the first two of its kind. i.e if 16 De's for 1st May, I need it to state 14. If 3 New then need it to state 1.

Obviously in the pivot table I can just drage Job type into the Values area and change from sum to count but this does not deduct the first 2 jobs. what calculated field sum/equation do I need to deduct the first two jobs.

Thank you very much.


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