Databases Reference
In-Depth Information
In many ways, the pivot table is similar to the straight table. However, you may
notice that there are a few differences:
• In a pivot table, expressions can be "rolled up" with subtotals (using the
Show Partial Sums
setting) for different levels.
• It is possible to drilldown to a deeper level by clicking on the expand icons.
This can be overridden, however, by enabling the
Always fully expanded
checkbox on the
Presentation
tab, which will make the table to always show
all possible dimension values.
• A cross-table can be created by dragging dimensions, like we just did
with the
Year
dimension. We can prevent this from happening by
unchecking the
Allow Pivoting
checkbox on the
Presentation
tab of
the
Chart Properties
window.
Auto minimize
We have now created two chart objects in our
Reports
sheet, a straight table and
a pivot table. These two tables do not necessarily need to be consulted at the same
time. Additionally, these objects would both benefit from being sized as large as the
screen space allows, so it's a good idea to display them one at a time.
Fortunately, while creating the tables we enabled the
Auto Minimize
option
(located on the
Caption
tab) for both of these objects. When the
Auto Minimize
option is set for an object, it is automatically minimized whenever another object is
restored. For this to work, the corresponding objects must have the
Auto Minimize
option enabled.
Let's make sure that both objects can utilize the maximum amount of space by
following these steps:
1. Minimize both the straight table and pivot table.
2. Position and resize the minimized tables in the space between the buttons
and the
Bookmarks
object.
3. Now, restore the straight table by double-clicking on its minimized icon.
4. Resize the table so that it occupies all the available space in the center of
the screen.
5. Next, restore the pivot table by double-clicking on its minimized icon. At this
point, the straight table should be automatically minimized; if it is not, then
check the
Auto Minimize
checkbox on the
Caption
tab for both objects.
6. Expand the fields in the pivot table and size it so that it uses all available
space in the center of the screen.
