Hello all,

Here's my crosstab query:

TRANSFORM Sum(([Month1]+[Month2]+[Month3])) AS Total
SELECT tblName.Product, Sum([Month1]+[Month2]+[Month3]) AS CatTotal
FROM tblName
GROUP BY tblName.Product
PIVOT tblName.Position;

It works well but I am trying to take it one step further:

Rather than the Sum of Month1, Month2 and Month3 by position and product, I want to show it in percentages (Sum of Month1, Month2, Month3 for a given product and position divided by CategTotal)

Current Results:

CatTotal......Pos2......Pos3......Pos4.........Pos 5
Prod1 216............26........176.........0............ ..14
Prod2 607............96........0...........357.......... 154
Prod3 607............96........0...........357.......... 154
Prod4 216............26........176.........0............ ..14

Desired Results:

CatTotal......Pos2......Pos3......Pos4............ .Pos5
Prod1 216............12%........81%.........0%.......... ....7%
Prod2 607............16%........0%...........59%........ ..25%
Prod3 607............16%........0%...........59%........ ..25%
Prod4 216............12%........81%.........0%.......... ....7%

(CatTotal doesn't necessarily have to be displayed)

Thanks for looking!

Norm