Actual Consumption Report: Specify an Analysis Area, the Level of Detail, and a Sort Method

On the Step 2 screen, specify a geography or an analysis area for which you want to generate the report, the level of detail that you want to include, and your preferred sort method.

Additional considerations:

  • When selecting the analysis areas or standard geographies you want to include in the report, clicking on the folder (without opening it) will select all areas contained within the folder.
  • Use the Search function to locate your desired analysis areas.
  • Use the Save List button to save your selected list of analysis areas for future use.
  • Use the My Lists button to load a previously saved list of analysis areas.
  • You can specify to append parent geographies in your report output.

To Learn More:

Actual Consumption Report - Interpretation & Calculations

  1. On the screen similar to the one above, below Select an Analysis Area, navigate to and select the geography or analysis area for which you want to generate a report. You can also use the Search function to look for your desired area.

  2. Below Select the level of detail, click the option that best describes how you want to arrange your selected geographies or analysis areas on your report. The options are:

  1. (Optional) To append parent geographies to the report, click the OFF button next to Include Parent Geographies to set it to ON. When the Parent Geography pop-up window appears, click the Name and/or Code check box next to the parent geography(ies) that you want appended to the report.


  1. Specify a method to use for sorting data in the report. The options are:
  • None
  • Row ID - Sorts data according to row identification number.
  • Row Name - Sorts data according to row name.
  • Report Selection - Sorts data based on a specific variable and measure.
  1. (Optional) If you selected Report Selection as your sort method, you need to specify a sort variable and a sort measure.
  2. Specify your preferred sort direction. The options are Ascending and Descending.
  3. (Optional) If you selected Report Selection as your sort method, you need to specify a subtotal method for sorting the data in your report. The subtotal method options are:
  • None
  • Equal Ranges: Groups areas (rows) based on the values of a specific variable – Each subtotal group will have an equal minimum/maximum range for the specified variable.
  • Equal Records: Uses basic division to group the number of areas (rows) equally – Each subtotal group will have an equal number of areas.
  • n-Tile: Distributes the total number of households in an area into groups that are approximately equal, such as fourths or fifths. Dividing data in equal portions ranks the analysis areas by marketing potential, in groups showing the strongest to weakest.
  1. If you selected the Equal Ranges or Equal Records subtotal method, you need to specify the following:
  • Number of ranges: In the Select the number of ranges drop-down list, click your desired number of groupings.
  1. If you selected the n-Tile subtotal method, you need to specify the following:
  • Number of ranges: In the Select the number of ranges drop-down list, click your desired number of groupings.
  • Subtotal measure: In the Select a Subtotal Measure drop-down list, click the desired measure to use for equal grouping.
  1. (Optional) If you want to include a map, do the following:
    1. Click the OFF button next to Include Map to set it to ON. Additional options appear.
    2. In the Select a color scheme drop-down list, select the color theme that you want to use in your map.
    3. By default, Include Labels is set to ON. To disable the labels, click the button to set it to OFF.
  1. Click Next to proceed.

What's Next:

Actual Consumption Report: Specify a Report Output Type and the Report Name