Microsoft Office Tutorials and References
In Depth Information
The empty grid report window is divided into several areas. The draft view of the report appears in the center
window. Beneath the center window are panels labeled Rows, Columns, and Background that will be used to specify
the contents of the report. In the report designer, “background” refers to the ways in which the data in the report can
To the right is a Details tree from which we’ll select items to add to the report by dragging them onto one of the
panels at the bottom of the window.
From the Details panel, drag Dimensions ➤ Sales Channel and drop it on the Columns panel.
From the Details panel, drag Measures ➤ Sales Amount and drop it on the Columns panel.
Drag and drop these measures to Columns as well: Total Product Cost, Gross Profit, and
Gross Profit Margin.
From the Details panel, drag Dimensions ➤ Product ➤ Categories and drop it on
the Rows panel.
Now that we have defined the rows and columns for the report (as shown in Figure 6-76 ), it will automatically
display a default view. In our dashboard, we want to see the product categories by default. We also want to be able
to filter this report by date, territory, and promotion.
Figure 6-76. Defining the report’s rows and columns
Right-click on Product Categories in the Rows panel, and choose Select Members.
Right-click on All Products, and select Autoselect Members ➤ Select Category.
Ensure that All Products and Category descendants of All Products are selected,
and click OK. (See Figure 6-77 .)
Search JabSto ::