> For the complete documentation index, see [llms.txt](https://openup.gitbook.io/wazimap-ng/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://openup.gitbook.io/wazimap-ng/profile-admin/subindicator-groups.md).

# Sub-Indicator groups (columns)

## Reordering subindicators

It might be that you want to change the order in which the sub-indicators are shown. For example, you may want to swap Agree and Disagree in the chart below

![](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MKdGzw0wNwJkrcxrxld%2F-MKd_xH6Gpqsd_OGvqek%2FScreen%20Shot%202020-10-27%20at%2010.59.28.png?alt=media\&token=8766c037-e102-4d30-8942-ea2508a2c9ef)

In the Admin Suite, find `SubindicatorsGroups`

![](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MKdGzw0wNwJkrcxrxld%2F-MKdaFiJFCBHbSxgEDaE%2FScreen%20Shot%202020-10-27%20at%2012.27.01.png?alt=media\&token=97863152-979d-46e4-b178-d44e0326bff6)

Find the relevant indicator:

![](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MKdGzw0wNwJkrcxrxld%2F-MKdaouvFkjStFvp4LZf%2FScreen%20Shot%202020-10-27%20at%2012.29.33.png?alt=media\&token=a32268bb-60cd-40e4-95c7-13a00f702c92)

Then drag the subindicators into the desired order:

![](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MKdGzw0wNwJkrcxrxld%2F-MKdb-x3dDoXmshQSEZf%2FScreen%20Shot%202020-10-27%20at%2012.30.26.png?alt=media\&token=da8a0a1b-4f96-41b1-aa83-14b3daa0612f)

The order should now be changed on the front-end. In order to see it you will need to hard-refresh your browser - ctrl + shift + R (this will be fixed soon).

![](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MKdGzw0wNwJkrcxrxld%2F-MKdhTgjrvVgamVtcSyF%2FScreen%20Shot%202020-10-27%20at%2012.58.38.png?alt=media\&token=7a22b2fe-80f2-4288-98b4-1085ad8f7bd1)

## Non-aggregatable columns

Values are summed over all dimensions other than the indicator variable by default. That means an indicator on the column "financial year" from a dataset with columns "financial year" and "income source" will disaggregate by financial year, and show the sum of the different income sources, unless the user adds a filter on income source.

It sometimes doesn't make sense to sum values over a dimension. For example

* If you don't know how many years are in a dataset, the total across years doesn't mean anything
* If your data contains overlapping categories to support differing standards, e.g. ages 15-24 and 15-35, summing over these would lead to double-counting.

You can mark a column as non-aggregatable by un-checking the `Can aggregate` check-box. It is checked by default as most columns are fine to aggregate over.

!["Can aggregate" unchecked.](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MdHjbWg2KKDOnAypF9K%2F-MdHlf2GyhQ1FEFwf558%2FScreenshot_2021-06-28_15-19-00.png?alt=media\&token=9368e54e-cb90-41de-bbd5-c8bfdfd7a22f)

This will mean that indicators from this dataset will automatically have a filter for this subindicator group, unless this group is used as the indicator variable (in which case it is already disaggregated).

Unlike user-added filters, filters added to disaggregate non-aggregatable columns can not be removed.

![A filter for non-aggregatable "age goup" and user-added gender filter](https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M02trgcnmNckA-WvFeq%2F-MdHmsYXQ8VDKmjKA7DP%2F-MdHo9yu44UJga2ajPXg%2FScreenshot_2021-06-28_15-30-29.png?alt=media\&token=f3c83fe6-3253-477b-a0dd-01ced2f5e112)

You can [specify which value should be the default to be matched in the filter in indicator config](https://openup.gitbook.io/wazi-ng-technical/profile-indicator-configuration#default-filters). E.g. to ensure that the latest financial year is the default value filtered against. Users can still choose other options if they wish.
