# Group by in the Query Editor

**URL:** <https://community.easymorph.com/t/group-by-in-the-query-editor/2514>\
**Category:** General Q&A\
**Created:** [February 26, 2021, 7:49am UTC](https://community.easymorph.com/t/group-by-in-the-query-editor/2514 "2021-02-26T07:49:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [February 26, 2021, 7:49am UTC](https://community.easymorph.com/t/group-by-in-the-query-editor/2514/1 "2021-02-26T07:49:13Z")

</div>

> Is there this possibility (Group by) in the Query Editor (by clicking somewhere)?  
> Example: I pick a dimension (a country) and a measure (Sales) and I want the output to be the SUM(Sales) by Country

Yes, it's possible. Right-click a column and pick aggregation type. If at least 1 column is aggregated, the rest of the columns will be used for grouping. Aggregated columns are indicated with a blue line.

 ![image](https://community.easymorph.com/uploads/default/original/2X/3/367423a876894ca36ab1ccdafbfdaccb485fc85f.png)

Also, when 1 or more columns are aggregated, their values can be _post-filtererd,_ i.e. filtered AFTER aggregation. For this, switch to the Post-filter condition tab, and specify a filtering condition just like in the regular Filter tab.

 ![image](https://community.easymorph.com/uploads/default/original/2X/b/b1a1224c39bb3622a06696d133c20aee469e1f57.png)