The next step is to create the cross tab that displays the
data with the Sales Forecast Factor applied.
1.
Right click the Report Header1 section header. Select Insert Section
Below from the pop-up menu.
2.
Right click in ReportHeaderSection1 and select InsertàCross Tab… from the pop-up menu.
3.
The Cross Tab Expert should appear. Click on the Forecast formula field
in the Available Field listbox. Click the > button next to the Summary
Fields listbox.
4.
Expand the SalesTerritory table in the Available Fields list and click
on the CountryRegionCode field. Click the > button to the left of the Rows
listbox.
5.
Click the Name field under the SalesTerritory table and click the >
button to the left of the Rows listbox.
6.
Scroll up to the OrderDate field under the SalesOrderHeader table in the
Available Fields listbox. Click the > button to the left of the Columns
listbox.
7.
Click on the Group Options button under the Columns listbox.
8.
In the "The column will be printed:" dropdown select "for
each quarter." and click the OK button.
9.
Click the OK button. The cross tab will appear in the
ReportHeaderSection1 section.
10. Change
the font for the summary field to regular and resize the fields as you did in
Step 5.