# Group period columns

{% hint style="info" %}
User permission: Budgets & Forecasts
{% endhint %}

The column header of the period column group identifies the periods (columns) in that group. The values you see in a period column group are the total of the values in the individual periods.

<div align="left"><figure><img src="/files/NdsTlAtgnrvZ4PwbPTgQ" alt="" width="510"><figcaption></figcaption></figure></div>

There are many reasons why you might want to group columns, such as to:

* Group past periods into one summary column, so that data is hidden from view and you can focus on the remaining months in the budget period.
* Group a couple of weeks together to view a fortnightly budget.
* Group three months together to get a summary total of the budget values in that quarter.
* View your budget values at a summary time period level, such as quarters, and avoid the need to scroll across the worksheet.

### Create a group <a href="#groupperiodcolumns-createagroup" id="groupperiodcolumns-createagroup"></a>

If you are the budget owner and you create column groups, the groups display initially in a ‘collapsed’ state for you; you cannot edit the values in the cells (white background). However, you can use the spread feature to change the total value. When contributors open the workbook, they will see those groups in the expanded state (yellow background), so they can edit the values (according to the workflow).

Contributors also have the ability to create column groups, to meet their data entry needs. These changes do not impact the column groupings set by the budget owner.

Column groups are retained the next time you (budget owner and contributors) load the workbook. However, they are removed when you copy a budget forward or change the start or end dates.

1. Click the header of the first period column you want to include in the group > hold and drag your mouse across the headers of the other columns you want to include in that group > release your mouse. The headers of the selected columns are highlighted blue and the grouping menu displays.
2. Select the required grouping method:
   * Click **Group period** to group the selected period columns into one ‘total’ column. You can repeat this action manually for other periods in the worksheet&#x20;

     <div align="left"><figure><img src="/files/IlUeHb99Sprwv62GEA7v" alt="" width="272"><figcaption></figcaption></figure></div>
   * Click **Group period forward** to group the selected period columns into one ‘total’ column and group the subsequent period columns in the same way. This quickly creates a batch of ‘repeating’ column groups based on the number of period columns in the first group.

     <div align="left"><figure><img src="/files/8j8Gku2f77NQKRz0mDQ9" alt="" width="272"><figcaption></figcaption></figure></div>

<figure><img src="/files/ngSuwnHcxmldjvVbyzsV" alt="" width="680"><figcaption></figcaption></figure>

### Expand or collapse a group <a href="#groupperiodcolumns-expandorcollapseagroup" id="groupperiodcolumns-expandorcollapseagroup"></a>

To view the period columns within a group, click the header of the group to expand the group. You can then edit the values as usual (yellow background) if you have been assigned tasks in the workflow.

Click anywhere in the blue highlighted column header area to collapse the group and view the group total again.

<div align="left"><figure><img src="/files/o3WTDCnNqwEutlzR8dEO" alt="" width="365"><figcaption></figcaption></figure></div>

### Spread totals within a group <a href="#groupperiodcolumns-spreadtotalswithinagroup" id="groupperiodcolumns-spreadtotalswithinagroup"></a>

In the collapsed state, you can use the [spread](/budgets-and-forecasts/contributor/edit-values-in-a-worksheet/spread-totals.md) feature to change the total values of a group and spread it across the periods within that group.

### Ungroup columns <a href="#groupperiodcolumns-ungroupcolumns" id="groupperiodcolumns-ungroupcolumns"></a>

Right-click anywhere in the blue highlighted column header area and click **Ungroup period** to ungroup that group, or click **Ungroup all** to remove all groupings.

<div align="left"><figure><img src="/files/ZoDcVhbFFPEysdMFOaRS" alt="" width="150"><figcaption></figcaption></figure></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.phocassoftware.com/budgets-and-forecasts/contributor/customize-your-view/group-period-columns.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
