Hi

I have been provided with daily sales data by account and by product. What I need to do is to see week by week whether or not there have been changes in the average selling price of our products.

My data contains a list of around 250 accounts and 500 products and has the fields:

Date

Product

Account

Average Selling Price

I need to see whether any individual accounts indidual products have changed in price from the previous week. I would then only like to display products from accounts where the variance is say greater than 5%. This will help me in determining which products from which accounts need to be looked at. Do I need to use the lookup function for this type of work? So that I dont end up displaying every product from every account.

Thanks

Chris