The noun TILE has 2 senses: 1. a flat thin rectangular slab (as of fired clay or rubber or linoleum) used to cover surfaces. 2. a thin flat slab of fired clay used for roofing. Familiarity information: TILE used as a noun is rare. â¢ TILE (verb).
In the At each change in box, click the nested subtotal column. For example, using the example above, you would select Sport. In the Use function box, click the summary function that you want to use to calculate the subtotals. For example, using the example above, you would select Sum.nsert the outer subtotals. How to insert the outer subtotals. On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed. In the At each change in box, click the column for the outer subtotals. For example, using the example above, you would click Region.
Sort the list on the field for which you want subtotals inserted. Click the Subtotal button in the Outline group on the Data tab. The Subtotal dialog box appears. Use the Subtotal dialog box to specify the options for the subtotals. Select the field for which the subtotals are to be calculated in the At Each Change In drop-down list.