Both of the options below start from the "Original" worksheet in the packaged workbook found in the Attachments section of this article.  Directions for creating the "Original" worksheet are included in the workbook.

• Option 1 - Use INDEX()
• Option 2 - Use a combined field calculation

Option 1: Use INDEX()

1. Select Analysis > Create Calculated Field...
2. In the Calculated Field dialog box that opens, do the following, and then click OK:
   1. Name the calculated field. In this example, the calculated field is named "Row Number"
   2. In the formula field, create a calculation similar to the following:

      INDEX()

3. Right-click [Row Number] in the data pane and select Convert to Discrete
4. Drag [Row Number] to the first position on the Rows shelf
5. Optional: right-click [Row Number] on the Rows shelf and uncheck Show Header

Note: the video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly.

Option 2 - Use Combined Field / Calculation

Combine the fields

1. Drag the Category and Sub-Category dimensions to the Rows shelf.
2. Double-click Sales in the Measures pane.
3. Ctrl-click Category and Sub-Category in Dimensions, right-click the highlighted fields, and then select Create > Combined Field.
4. Drag the combined Category & Sub-Category field to the far left on Rows.
5. Right-click Category & Sub-Category on Rows, and then clear Show Header.

Use Combined Calculation

1. Select Analysis > Create Calculated field... 
2. In the Calculated Field dialog box that opens, do the following, and then click OK:
   1. Name the calculated field. In this example, the calculated field is named "Combined"
   2. In the formula field, create a calculation similar to the following:

      [Region]+[Category]+[Sub-Category]

3. Drag [Combined] to the far left on the Rows shelf
4. Right-click [Combined] on Rows, and then uncheck Show Header

Note: The combined field must produce a unique value for each row in order to repeat the header in every row

The video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly.