Let's take a look at a few other examples of what happens when you add additional dimensions. For example, if you check Quarter of Order Date, you'll see Tableau highlight a partition defined by Region and Year of Order Date, with Index incrementing by the addressing fields of Quarter of Order Date and then Department:
If you were to select Department and Year of Order Date as the addressing of Index, you'd see a single partition defined by Region and Quarter, like this:
You'll notice, in this view, that Index increments for every combination of Year and Department within the partition of Quarter and Region.
These are a few of the other things to consider when working with addressing and partitioning:
- You can specify the sort order. For example, if you wanted Index to increment according to the value of the sum of sales, you could use the drop-down list at the bottom of the Table Calculation editor to define a custom sort.
- The At the Level option in the edit Table Calculation dialog box allows you to specify a level at which the Table Calculations are performed. Most of the time, you'll leave this set at Deepest (which is the same as setting it to the bottom-most dimension), but occasionally, you might want to set it at a different level if you need to keep certain dimensions from defining the partition but need the Table Calculation to be applied at a higher level. You can also reorder the dimensions by dragging and dropping within the checkbox list of Specific Dimensions.
- The Restarting Every... option effectively makes the field selected, and all dimensions in the addressing above that field selected, part of the partition, but allows you to maintain the fine-tuning of the ordering.
- Dimensions are the only kinds of fields that can be used in addressing; however, a discrete (blue) measure can be used to partition Table Calculations. To enable this, use the drop-down menu on the field and uncheck Ignore in Table Calculations.
Take some time to experiment with various options and become comfortable with how addressing and partitioning works.