Amazon VBA Manuel d'utilisateur Page 8
- Page / 60
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
AllowMultipleFilters Indicates whether a pivot field can have multiple
filters applied to it at the same time.
CompactLayoutColumnHeader Specifies the caption that is displayed in the col-
umn header of a pivot table when in compact
row layout form.
CompactLayoutRowHeader Specifies the caption that is displayed in the row
header of a pivot table when in compact row
layout form.
CompactRowIndent Indicates the indent increment for pivot items
when compact row layout form is turned on.
DisplayContextTooltips Controls whether ToolTips are displayed for
pivot table cells.
DisplayFieldCaptions Controls whether filter buttons and pivot field
captions for rows and columns are displayed in
the grid.
DisplayMemberPropertyTooltips Controls whether to display member properties
in ToolTips.
FieldListSortAscending Controls the sort order of fields in the
PivotTable Field List. When this property is
True, the fields are sorted in alphabetical order.
When it is set to
False, the fields are presented
in the same sequence as the data source
columns.
InGridDropZones Controls whether you can drag and drop fields
onto the grid. Changing the pivot table layout
also changes this property. Changing this pro-
erty forces the layout back to a table layout.
LayoutRowDefault Specifies the layout settings for pivot fields
when they are added to the pivot table for the
first time. Valid values are
xlCompactRow,
xlTabularRow, or xlOutlineRow.
PivotColumnAxis Returns a PivotAxis object representing the
entire column axis.
PivotRowAxis Returns a PivotAxis object representing the
entire row axis.
PrintDrillIndicators Specifies whether drill indicators are printed
with the pivot table.
Chapter 11 Using VBA to Create Pivot Tables
238
11
Table 11.2 Continued
Property Description
12_0789736012_CH11.qxd 12/11/06 6:26 PM Page 238
- Using VBA to Create Pivot 1
- Enabling the Developer Ribbon 2
- Visual Basic Editor 2
- Visual Basic Tools 3
- Learning Tricks of the Trade 4
- Understanding Versions 6
- New in Excel 2007 7
- Table 11.2 Continued 8
- Property Description 9
- Figure 11.3 11
- Figure 11.4 12
- Figure 11.5 13
- Figure 11.6 14
- Listing 11.2 Continued 16
- Figure 11.8 17
- Figure 11.9 20
- In Excel 2000 and earlier 21
- Filling the Outline View 22
- Handling Final Formatting 22
- Adding Subtotals 23
- Putting It All Together 24
- Listing 11.3 Continued 26
- Figure 11.11 27
- Calculated Data Fields 28
- Calculated Items 30
- Figure 11.14 31
- Listing 11.5 Continued 32
- Figure 11.16 33
- Figure 11.15 33
- Figure 11.17 34
- Group by Week 35
- Figure 11.18 36
- Figure 11.19 38
- Figure 11.20 40
- Listing 11.9 Continued 42
- Figure 11.21 43
- Listing 11.10 Continued 44
- Creating Report Percentages 47
- Percentage of a Specific Item 48
- Running Total 48
- Using the New Filters 49
- Figure 11.23 50
- Table 11.3 Filter Types 51
- Table 11.3 Continued 52
- Filter Type Description 53
- Applying a Table Style 54
- Changing the Layout 55
- Applying a Data Visualization 56
- Next Steps 59
Produits connexes et manuels pour Logiciel Amazon VBA
Logiciel Amazon AWS SDK Manuel d'utilisateur
(29 pages)
(29 pages)
Logiciel Amazon AWS SDK Manuel d'utilisateur
(26 pages)
(26 pages)
Logiciel Amazon AWS SDK Manuel d'utilisateur
(28 pages)
(28 pages)
Logiciel Amazon AWS SDK Guide d'installation
(151 pages)
(151 pages)
Logiciel Amazon Redshift Guide de l'utilisateur
(255 pages)
(255 pages)
Logiciel Amazon AWS SDK Guide de l'utilisateur
(155 pages)
(155 pages)
Samsung LRS35LMGLM manuály
Uživatelské manuály a uživatelské příručky pro ne Samsung LRS35LMGLM.
Poskytujeme 1 manuály pdf Samsung LRS35LMGLM ke stažení zdarma podle typů dokumentů: Uživatelský manuál
Commentaires sur ces manuels