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