Cross Tab Totaling

W

Welly

I have a query that totals the revenue by weeks, how can i then have an
overall total?

TRANSFORM Sum([7 2005 and 2006 Sales data by week 1-18].[TurGN-NT1]) AS
[SumOfTurGN-NT1]
SELECT [7 2005 and 2006 Sales data by week 1-18].Customer
FROM [7 2005 and 2006 Sales data by week 1-18] INNER JOIN [Week to Date
conversion table] ON [7 2005 and 2006 Sales data by week 1-18].Week = [Week
to Date conversion table].Week
GROUP BY [7 2005 and 2006 Sales data by week 1-18].Customer
PIVOT [Week to Date conversion table].Date;
 
K

Ken Sheridan

Try:

TRANSFORM Sum([7 2005 and 2006 Sales data by week 1-18].[TurGN-NT1]) AS
[SumOfTurGN-NT1]
SELECT [7 2005 and 2006 Sales data by week 1-18].Customer,
Sum([7 2005 and 2006 Sales data by week 1-18].[TurGN-NT1]) AS OverallTotal
FROM [7 2005 and 2006 Sales data by week 1-18] INNER JOIN [Week to Date
conversion table] ON [7 2005 and 2006 Sales data by week 1-18].Week = [Week
to Date conversion table].Week
GROUP BY [7 2005 and 2006 Sales data by week 1-18].Customer
PIVOT [Week to Date conversion table].Date;

Ken Sheridan
Stafford, England
 
Top