Hello: Is there a way to add a field in a pivot table that will count another Pivot field if it is the max otherwise display a 0? I have attached the sample snapshot of the pivot that I am trying to achieve. I am basically trying to add the field in yellow. So, if percent time is the max for the respective JOB #, then display a 1 in the number of jobs field, and if it is not the max, then display a 0. Is there a way to achieve this? I have been trying for over a day with no luck. Any help would be appreciated.
If this is not possible in a pivot format, then is there a macro that could achieve the same thing with the actual data?
Thanks for the help.
Bookmarks