If the Sales Analysis crosstab that you defined is not already open, right-click Sales Analysis Crosstab and select Open.

In the toolbar that is located above the crosstab in the Presentation Editor, select the Format Crosstab tool (which is the second tool on the toolbar and appears to the right of the Query Editor tool).

The Crosstab Customizer is displayed.

3.

In the Crosstab Customizer, select the Titles tab. Enter Regional Sales Summary as the title of the crosstab. Note that the Show Title option is automatically selected as you enter the title text.

Click Title Font to open the Font dialog box. Change the title font properties as follows:

	Size: 18
	Style: Bold
	Color Text: Blue

Click OK to return to the Titles tab.

Enter Stoplight Report as the subtitle of the crosstab.

Then, click OK to apply the title formats and close the Crosstab Customizer.

From the File menu, select Save All to save all the changes. The Sales Analysis Crosstab Title area looks like the following figure:

With the Sales Analysis Crosstab displayed, click the Format Crosstab button to open the Crosstab Customizer. Select the Format tab.

To create the first header format, click the New Header Format button to open the Conditional Header Format dialog.

In the General tab and specify the following format options:

	Format Name: Americas
	Background Color: Blue

In the Conditional Header Format dialog, select the Font tab and specify the following format options:

	Font Style: Bold
	Font Text Color: White

In the Conditional Header Format dialog, select the Members tab. In the Dimension box, choose Geography.

In the Apply Format to section, choose the Selected Geographies option. In the Available list, select Americas. Add it to the Selected list by clicking the Copy ' > ' button.

Click OK to return to Crosstab Customizer.

To create the second header format, click New Header Format to open the Conditional Header Format dialog.

In the General tab, specify the following format options:

	Format Name: Northern America and Southern America
	Background Color: Yellow

In the Conditional Header Format dialog, select the Font tab and specify the following format options:

	Font Style: Bold
	Font Text Color: Black

In the Conditional Header Format dialog, select the Members tab. In the Dimension box, select Geography. Choose the Selected Geographies option. In the available list, select Northern America and Southern America. Add these two members to the selected list.

Click OK to return back to Crosstab Customizer.

Now, format the Product headers using the Fomatting toolbar.

Click the Product dimension tile grabber to select all product tiles. Then, click the Fill Color tool on the toobar to change the background color to Red.

With the Product dimension tiles still selected, click the Font Color tool and select White.

Finally, click the Bold tool.

From the File menu, select Save All to save all the changes. The crosstab should look like the following figure:

Optionally, you can also create header formats for the top two levels of the European Areas saved selection. These header formats will look exactly the same as the those you just created for the Amearica Areas selection.

Before creating the new header formats the European Areas saved selection, first, replace the current Geography selection by performing the following:

Click OK to refresh the query with the European Areas selection.

Use the Formatting toolbar to create the formats for the European dimension members. Using the Fill Color, Font Color, and Bold tools, specify the following formats:

When you are finished, the header formats should look similar to the following figure:

Click Save.

Finally, replace the European Areas selection with the America Areas selection.

From the File menu, select Save All to save all the changes.

Select Property Inspector from the View menu in JDeveloper to display the Property Inspector window. If structure window is not open, select Structure from View menu.

The JDeveloper window looks like the figure shown below:

Select Sales Analysis Crosstab in the Structure window. The Property Inspector is updated to show the properties of the crosstab.

In the Property Inspector, click in the value field next to the gridColor property. Then, click the ellipsis button (...) to open the gridColor dialog. In the Standard Colors box, select color.blue.

Click OK . Notice that the grid color has changed to blue.

In the Structure Window pane, expand Sales Analysis Crosstab and select dataviewTitle.

In the Property Inspector, select True for the underline property value.

Notice that the title text becomes underlined.

In the Structure Window pane, expand the columnHeader node and select viewStyle. In the Property Inspector, select True for the wordWrapEnabled property value.

This setting will enable wrapping of column heading text when you resize the crosstab columns.

From the File menu, select Save All to save your work.

Close the Property Inspector by clicking its close tool (' X ').

With the Sales Analysis Crosstab displayed, click the Edit Query tool to open the Query Wizard. Select the Items tab.

In the Available list, select the Sales Revenue Growth % calculation that you created in a previous lesson. Click the Add Selected Items button (' >') to move the calculation to the Selected list.

As stated at the beginning of this topic, the analytic requirements for this crosstab do not include the Promotion dimension. To remove the Promotion dimension from the query, click Promotion in the Selected list and then click the Remove Selected Items button (' <').

The resulting Items selection for this query should now look like this:

Sales Revenue Growth % measure calculates percentage growth on Sales Revenue based on data a year ago. Since 1998 is the first year of data, there are no data values on which to calculate percent growth. In addition, there are no data values stored for 2002.

Therefore, for change the Time dimension selection to include the years 1999 - 2001.

Click OK to update the query.

Resize the column widths to view more data as shown here. The text in the measure headings wraps because of the property setting you selected in the previous subtopic.

Select 2000 from the Time dimension tile and note the changes in the data. Scroll to the right using the scroll bar to view more Product catagory data.

To create the stoplight format, click the Format Crosstab tool to open the Crosstab Customizer.

Select the Format tab and then click New Stoplight Format. The New Stoplight Format dialog box is displayed.

In the New Stoplight Format dialog box, enter or select the following values:

	Format Name:	Sales Growth Stoplight
	Apply Format To:	Sales Revenue Growth %
	Threshholds:	Unacceptable: 0
		Desirable: 0.3

The New Stoplight Format dialog box should look like this:

Click OK to create the format.

In the Crosstab Customizer, select Cell Formats from the View drop-down box to display your new stoplight format.

Ensure that the Hide Data Values for Stoplight Formats option is not selected. If you select this option, then only the stoplight colors, and not the data values, are displayed for the selected measure data.

Click OK to apply the format to the crosstab.

The stoplight format should display the following results:

Select other members from the Time and Channel dimension tiles and see how the stoplight formatting updates along with the data.

If the Sales Analysis graph that you defined is not already open, then right-click Sales Analysis Graph and select Open.

In the toolbar that is located above the graph on the Presentation Editor, select the Format Graph tool (which is the third tool on the toolbar).

The Graph Customizer dialog box opens.

In the Graph Customizer, select the Titles tab. Enter Sales in America as the title of the graph.

Click Title Font to open the Font dialog box. Change the following title font properties as follows:

	Size: 20
	Style: Bold
	Color Text: Blue

Click OK to return to the Titles tab.

Enter Top 5 Products in Photo Division as the subtitle of the graph.

Click Subtitle Font to display the Font dialog box. Change the following subtitle properties as follows:

	Size: 16
	Style: Bold
	Color Text: Blue

Click OK to return to the Titles tab. Then, click OK to close the Graph Customizer.

As you did with the crosstab, remove the Promotion dimension from the graph by performing the following steps:

Still in the Query Wizard, remove the year 2002 from the Time dimension by performing the following:

The graph now looks like this:

From the File menu, select Save All to save all the changes.

To change the graph type, click the Graph Type tool on the Presentation Editor toolbar.

The Graph Type dialog opens. Select Horizontal Bar as the graph type.

Then, click the Graph Style tab and select the 3D Effect option.

Click OK to change the graph type.

To remove the gridlines from the graph, click the Show Grid toolbar item, which is a toggle.

The gridlines are removed.

To change the background color of the graph, click in the body of the graph and then click the Fill Color tool.

Change the fill color to pastel lemon.

To change the bar color of 5MP Telephoto Digital Camera, select the bar that corresponds to that product and click the Fill Color tool. Then select the color Red.

The formatted graph should look something like this:

From the File Menu, select Save All to save your work.

Select Property Inspector from the View menu in JDeveloper to display the Property Inspector window. If the structure window is not open, select Structure from View menu.

The JDeveloper window is shown below:

Expand Sales Analysis graph in the Structure window by clicking on the drill ('+') symbol.

To modify the font of the Y Axis Tick Labels, scroll down the list of subcomponents under Sales Analysis Graph, and click y1TickLabel.

In the Property Inspector, click in the Font property value. Then, click on the elipsis (...) button to open the font dialog box.

Set the Size to 12, and select Bold. Then, click OK to close the font dialog box. The graph Y1 Tick Labels are updated with the new formatting.

Now, modify the font of the ordinal axis labels by following these steps:

The graph now should look like this:

Close the Property Inspector.

Finally, use the Formatting toolbar to establish two more modifications. Click the Show Grid tool in order to re-establish grid lines. Then, click the Gradient Effect tool item, which is just to the right of the Show Grid tool.

The finished graph should look like this:

From the File Menu, select Save All to save your work.

You can select new members from any of the dimension tiles to update the graph.

In addition, you can experiment with the graph by using the Query Wizard to select new dimension members, including your European Areas saved selection.