Year-over-year sales growth

[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.

 

[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;

 

[Guest]

Thanks Karl, but I'm still having a tough time with this.

Maybe if use the Summary of Sales by Quarter report found in the Northwind
database you may be able to show me how to calculate year over year growth
for each QTR.

Thanks again

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;

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.

 

[Guest]

You did not state what your problem was.

Thanks Karl, but I'm still having a tough time with this.

Maybe if use the Summary of Sales by Quarter report found in the Northwind
database you may be able to show me how to calculate year over year growth
for each QTR.

Thanks again

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;

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.