I have setup a pivot table that shows the service levels by customer. This shows the customer, cases ordered, cases delivered, variance and the service level, which is shown as a percentage on each line of the data.
However I can't get the service level to show accurate totals because it totals up the percentages and if I use average, whilst it is accurate in the grand total it is not in the customer total. The service levels is calculated as cases delivered / cases ordered.
Thanks for you help,
Roly
Bookmarks