Microsoft Office Tutorials and References
In Depth Information
With all this theory in mind, you can now learn how to define a set by using Excel. On the
Options tab of the Excel ribbon, you can find a button named Fields, Items, & Sets that
contains the links to the feature we are interested in. Look at Figure 8-32.
FIguRE 8-32 The various options for creating sets in Excel.
By means of this menu, you can create a set using the values in the rows or columns of the
PivotTable. If you select Create Set Based On Row Items in your PivotTable, Excel opens the Set
Editor dialog box shown in Figure 8-33.
FIguRE 8-33 Set Editor dialog box.