Microsoft Office Tutorials and References
In Depth Information
FIguRE 2-14 The Rename Column option of the column menu, available with a right-click.
In Figure 2-15, you can see the final result, showing both the new column and the formula
bar for the calculated column.
FIguRE 2-15 The formula bar with the calculated column.
Now that you have a good description of the order type, you can safely hide the column
OnlineOrderFlag, which now has become a technical column. (It contains a value needed
to compute the description, but you want to browse and slice data using the description
defined in the new Order Type column and not the original value.) After you do that, you
can use the new OrderType field in a PivotTable, and the result looks like Figure 2-16.