2 Replies Latest reply on Jan 25, 2012 6:12 AM by Christopher Henderson

    Lookups and Variances

    Christopher Henderson

      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