Adding a count if max field to a PIVOT table

[rlsublime]

Hello:

I have a Pivot table that displays "Percentage of time spent on a Job" by employee. I am trying to add a custom field that only counts the JOB if the JOB is the max.

So if I have
Bill 6%
Jim 4%
Mark 90%

I would be interested in trying to add a field "# of Jobs" that only counts Mark since he had the highest percentage. I am trying to get the output as follows:

Bill 0
Jim 0
Mark 1

Thanks for your help in advance.

[shg]

Duplicate post, thread closed.

Please take a few minutes to read the forum rules before posting again.

Thanks.