Orders - NA & EMEA | Pentaho Academy

To select the Data Source and Report Template.

From the User Console Home Perspective, click Create New > Interactive Report.
In the Select Data Source window, click Orders, and then click OK.
In the Selection Pane, click the General tab, and then click Select.
Use the left and right arrow to scroll through the available templates, and then select: Left Aligned - Cobalt.
From the top Toolbar panel: In the Row Limit box, enter No more than 100.

To add Product Name, Order Number, Order Date, Status, Quantity Ordered, and Total to the report.

In the Selection Pane, click the Data tab.
Select Product Name from the Data panel, and drag it to the Report Canvas.
Select Order Number from the Data panel, , then drag it to the Report Canvas and drop it to the right of Product Name.
Add the following additional fields:
• Hold the Ctrl key
• Select Order Date, Status, Quantity Ordered, and Total.
• Right-click & Select Add to Columns.
In the Interactive Toolbar, click the Layout button.
Click Order Date and drag it between Product Name and Order Number.

To add a report group for Territory and a subgroup for Product Line.

From the Data panel, drag Territory to the Report Canvas and place it above the column headers.
From the Data panel, drag Product Line to the canvas and place it below the Territory group.

To sort the Order Date column.

Click the drop-down arrow next to the Order Date column header, and then select Sort > Ascending.

To filter the report to only show shipped orders on or after January 1, 2005 for EMEA and NA.

On the Interactive Toolbar, click the Filter button.
From the Data panel, select Territory and drag it to the Filters panel.
In the Filter on Territory dialog box:
• Select: Select from a list.
• From the list of values, hold the Ctrl key and click EMEA and NA.
• Click the right arrow to move EMEA and NA to the Currently Included list.
• Click OK.
In the report details, click the Status column header and drag it to the Filters panel.
In the Filter on Status dialog box:
• Select: Select from a list.
• From the list of values, click Shipped.
• Click the right arrow to move Shipped to the Currently Included list.
• Click OK.
In the report details, click the Order Date column header and drag it to the Filters panel.
In the Filter on Order Date dialog box:
• From the available constraints drop-down list, select On or after.
• Click the next drop-down arrow.
• Navigate to January 2005.
• Select January 1, 2005 (2005-01-01)
• Click OK.

To add totals for the Total and add labels for the subtotal and grand total lines.

To add totals for the Total column, in the report details:
• Click the drop-down arrow next to the Total column header.
• Click Summary.
• Click Sum.

You may need to set the Row Limit to: Maximum

Add a report title, add text to the report header, resize the columns, and reformat column headers and data:

Save the report to the repository:

To save the report, on the toolbar click the Save icon.
To save the report:
• In the Filename field, type Shipped Orders Activity – Jan 1st 2005.
• For the location, click the Up One Level icon twice.
• In the list of folders, double-click Public.
• In the list of folders, double-click Training & Save.