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
    Ashdoc's Movie Review---The Salesman ( Iranian Film ) Theatre, Movies & Cinema Apr 14, 2017
    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

  3. OP
    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.
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page