![]() |
calculation field in a Pivot Table
I can't seem to be able to create a calculation field in a Pivot table. I
have a Pivot table that tells me the number of times a vendor has delivered "on time". the original table has columns that state whether each line of a Purchase order was delivered either 'on time', 'under' or 'over'. we also keep track of any delivery issues that may have occurred on the same sreadsheet. we call them 'NCM' and 'SCAR'. What I want the pivot table to do is to take the total number of times a vendor delivered on time and deduct from that the number of times they delivered over, under and ding them if they have any NCM's or SCAR's; take that amount and come up with some type of grading or score for that particular vendor. Can anybody out there help? |
All times are GMT +1. The time now is 08:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com