# Why can't I add row/columns totals on my tables?

**URL:** <https://community.omni.co/t/why-cant-i-add-row-columns-totals-on-my-tables/84>\
**Category:** Workbooks\
**Created:** [May 31, 2024, 6:51pm UTC](https://community.omni.co/t/why-cant-i-add-row-columns-totals-on-my-tables/84 "2024-05-31T18:51:02Z")\
**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:** [May 31, 2024, 6:51pm UTC](https://community.omni.co/t/why-cant-i-add-row-columns-totals-on-my-tables/84/1 "2024-05-31T18:51:03Z")

</div>

Row/column totals only work on [measures](https://docs.omni.co/docs/modeling/measures) (aggregate fields). If you’d like to include a row/column total on a [dimension](https://docs.omni.co/docs/modeling/dimensions), you can often swap your dimensions for an aggregate.

For example, if you have a dimension for Sale Price, adding a column total won’t work. But if you make that dimension into a measure with a quick aggregation, then that column total will work.

If you want a quick total on a dimension without converting it to a measure, you can use Excel calcs to do so — i.e. " =sum(B:B)" will give you the column total for column B.