Queries :: Crosstab Query With No Aggregation

I have the table "tblProductionForecast" with the following fields:

ProductionForecastProductId
ProductionForecastMonth
ProductionForecastQuantity

I want to show this in a report, similar to an spreadsheet, with:

ProductionForecastProductId = Rows
ProductionForecastMonth = Columns
ProductionForecastQuantity = Data

I thought of using a crosstab query like this:

Code:
TRANSFORM avg(tblProductionForecast.[ProductionForecastQuantity]) AS AvgOfProductionForecastQuantity
SELECT tblProductionForecast.[ProductionForecastProductId]
FROM tblProductionForecast
GROUP BY tblProductionForecast.[ProductionForecastProductId]
PIVOT tblProductionForecast.[ProductionForecastMonth];

but I don't want the average of ProductionForecastQuantity. I want the actual value!

Is a crosstab query the wrong method to use?

If no, how do I show the actual value of ProductionForecastQuantity

If yes, how should I create the report?