Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Year-over-year sales growth

Discussion in 'Information Technology' started by ron, Jul 28, 2006.

  1. ron

    ron
    Expand Collapse
    Guest

    I'm trying to add a field in a report that shows year over year sales growth.

    Imagine a table with the following fields:
    Year - Sales
    2005 $100,000
    2004 $50,000

    In a report I want to show the growth but don't know how I would build the
    expression.
     
  2. Loading...

    Similar Threads Forum Date
    USA Sikh Car Salesman Reaches Settlement With Lexus Dealership Breaking News Nov 30, 2013
    Luxury Car Sales Boom in Punjab, Haryana Business, Lifestyle & Leisure Aug 27, 2011
    India Tata Nano's Nov sales one-sixth of Oct figures Breaking News Dec 7, 2010
    UK Kachera sales opportunity ! lol Breaking News Aug 26, 2010
    Sikhism Rocket Singh - Salesman of the Year Videos Oct 29, 2009

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    I built two queries to pull the data. I based the table on the data you
    presented.

    Ron_Sales_Past --
    SELECT Ron_Sales.Year, [Year]-1 AS [Past Year], Ron_Sales.Sales
    FROM Ron_Sales;

    SELECT [Ron_Sales].[Year]+1 AS [Sales Year], Ron_Sales_Past.Sales AS
    [Current Year], Ron_Sales.Sales AS [Year Ago Sales],
    [Ron_Sales_Past].[Sales]-[Ron_Sales].[Sales] AS [Growth over last year]
    FROM Ron_Sales INNER JOIN Ron_Sales_Past ON Ron_Sales.Year =
    Ron_Sales_Past.[Past Year]
    ORDER BY [Ron_Sales].[Year]+1;

    "ron" wrote:

    > I'm trying to add a field in a report that shows year over year sales growth.
    >
    > Imagine a table with the following fields:
    > Year - Sales
    > 2005 $100,000
    > 2004 $50,000
    >
    > In a report I want to show the growth but don't know how I would build the
    > expression.
     

Share This Page