Calculated Items: Operate on specific items within a field and add new rows to your Excel PivotTables. They are best suited for analyzing individual data subsets or comparisons.

Excel’s Data Model creates a relationship between two (or more) sets of data using a common field. In this case, the common field is Shelf Code, as shown in Figure A .