Product Analysis in Pivot Tables

[pensworth]

Hi All,

I have created a Pivot table as below:

Milk 1 Pint Whole

JAN FEB MARCH APRIL etc
Shop 1 10 12 14 20
Shop 2 8 7 6 2
Shop 3 10 10 10 10
Shop 4 20 30 40 50

Although i can manually look at the sales figures and work out if they are buying less or more products i would like a a more automatic way of finding out if customers sales are going down on the up or staying constant. Does anymore have any ideas on how best to acheive this.

Many Thanks

Mike