Hi there,
I currrently have a crosstab query where the monthy volumes are exctracted and I have a formula to calculate the total commission by product YTD.
Is there a way to show on another column just the previous month's commission?
Grand Total 2003 / 11 2003 / 12 2004 / 01
$17.64 77.00
$1.02 10.00 21.00 15.00
$4,374.48 44,941.00 42,272.00 47,051.00
$11,559.43 17,272.00 9,330.00 3,613.00
$2,719.08 20,750.00 19,511.00 38,600.00
$183,782.11 201,766.00 240,729.00 226,430.00
$4,840.49 150.00 154.00 25,810.00
My SQL is:
TRANSFORM Sum([ImpressionPrices Query].[Total Impressions]) AS [SumOfTotal Impressions]
SELECT [ImpressionPrices Query].Client, [ImpressionPrices Query].Form, [ImpressionPrices Query].Price, Sum([ImpressionPrices Query].SubTotal) AS SubTotal, Sum([ImpressionPrices Query].GST) AS GST, Sum([ImpressionPrices Query].PST) AS PST, Sum([ImpressionPrices Query].[Grand Total]) AS [Grand Total], Sum([ImpressionPrices Query].[Total Impressions]) AS [Total Impressions]
FROM [ImpressionPrices Query]
GROUP BY [ImpressionPrices Query].Client, [ImpressionPrices Query].Form, [ImpressionPrices Query].Price
ORDER BY [ImpressionPrices Query].[Billing Month] DESC
PIVOT [ImpressionPrices Query].[Billing Month];
Thanks in advance,
Kastaman
I currrently have a crosstab query where the monthy volumes are exctracted and I have a formula to calculate the total commission by product YTD.
Is there a way to show on another column just the previous month's commission?
Grand Total 2003 / 11 2003 / 12 2004 / 01
$17.64 77.00
$1.02 10.00 21.00 15.00
$4,374.48 44,941.00 42,272.00 47,051.00
$11,559.43 17,272.00 9,330.00 3,613.00
$2,719.08 20,750.00 19,511.00 38,600.00
$183,782.11 201,766.00 240,729.00 226,430.00
$4,840.49 150.00 154.00 25,810.00
My SQL is:
TRANSFORM Sum([ImpressionPrices Query].[Total Impressions]) AS [SumOfTotal Impressions]
SELECT [ImpressionPrices Query].Client, [ImpressionPrices Query].Form, [ImpressionPrices Query].Price, Sum([ImpressionPrices Query].SubTotal) AS SubTotal, Sum([ImpressionPrices Query].GST) AS GST, Sum([ImpressionPrices Query].PST) AS PST, Sum([ImpressionPrices Query].[Grand Total]) AS [Grand Total], Sum([ImpressionPrices Query].[Total Impressions]) AS [Total Impressions]
FROM [ImpressionPrices Query]
GROUP BY [ImpressionPrices Query].Client, [ImpressionPrices Query].Form, [ImpressionPrices Query].Price
ORDER BY [ImpressionPrices Query].[Billing Month] DESC
PIVOT [ImpressionPrices Query].[Billing Month];
Thanks in advance,
Kastaman