# Step 3: Create a Sort Field

> Tutorial 2 for Pro Version: Using Report Bands

## Step 3 - Create a Sort Field

### Key Concept

* **Sorting** and **Groups/Bands** are inextricably tied together.  
  * Report bands will generate *every time* the field you are grouping by changes.
  * IF your data is NOT sorted correctly, you'll get "duplicate" bands in your report, each with incomplete data.
* **Whenever you create a group, you should create a matching Sort Field.**

To create a Sort Field,

* Go to your **Outline** tab
* **Right-click** on "Sort Fields"
* Select **"Create Sort Field"**
* Select the **Current Site Name** field (or whatever field you create a Group for)
* Click OK  

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_2_Pro_Version_Create_Sort_FieldResize.jpg)

[**>> Continue to Step 4. >>**](https://colah.gitbook.io/illuminate-bi-tool-guide/tutorials/tutorials-for-pro-version-professional-edition/tutorial-2-using-report-bands/step-4-copy-and-paste-your-chart)