# Why isn't my dimension aggregating? Why isn't my number a sum/average/median/etc.?

**URL:** <https://community.omni.co/t/why-isnt-my-dimension-aggregating-why-isnt-my-number-a-sum-average-median-etc/96>\
**Category:** Workbooks\
**Created:** [June 3, 2024, 11:21pm UTC](https://community.omni.co/t/why-isnt-my-dimension-aggregating-why-isnt-my-number-a-sum-average-median-etc/96 "2024-06-03T23:21:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![conner](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conner/32/11_2.png) [@conner](https://community.omni.co/u/conner)\
**Post date:** [June 3, 2024, 11:21pm UTC](https://community.omni.co/t/why-isnt-my-dimension-aggregating-why-isnt-my-number-a-sum-average-median-etc/96/1 "2024-06-03T23:21:33Z")

</div>

[Dimensions](https://docs.omni.co/docs/modeling/dimensions) are attributes that describe a given row of data, and [measures](https://docs.omni.co/docs/modeling/measures) aggregate dimensions. In Omni’s field picker, dimensions are listed in black while measures are listed in green.

 ![dimensions_and_measures](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/fccde6e110f1f00836d28f5228c57147f82b388b.png)

If you’re selecting a field expecting it to be an aggregate, but instead you’re getting a list of possible values, you’ve probably selected a dimension, not a measure. Omni offers a quick way to create new measures — just right-click the field and select one of the quick aggregate options. Check out [this post](https://community.omni.co/t/how-do-i-create-a-quick-aggregation-sum-count-average/76) for more.

 ![quick_aggregates](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/eace3d432d13ee1ead7b49ecb8917921dc91c6ef.png)

For example, if you’re looking at Orders data, each row represents one order, and each order will have a value for the dimension called `sale_price`. If you select `sale_price` from the field picker, you’ll get a list of all possible `sale_price` values rather than a sum (or other aggregate) of `sale_price` values. You can use Omni to quickly create a Sum version of this field, e.g. `total_sale_price`, that will aggregate `sale_price` across all selected rows.

 ![Screenshot 2024-06-03 at 4.19.18 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/6046484d076526eadb2503d314a5282733f7861c.png)