# Why don't my column / row totals match the values in the table?

**URL:** <https://community.omni.co/t/why-dont-my-column-row-totals-match-the-values-in-the-table/82>\
**Category:** Workbooks\
**Created:** [May 31, 2024, 12:27am UTC](https://community.omni.co/t/why-dont-my-column-row-totals-match-the-values-in-the-table/82 "2024-05-31T00:27:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anika](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/anika/32/12_2.png) [@anika](https://community.omni.co/u/anika)\
**Post date:** [May 31, 2024, 12:27am UTC](https://community.omni.co/t/why-dont-my-column-row-totals-match-the-values-in-the-table/82/1 "2024-05-31T00:27:25Z")

</div>

In some cases, you may notice that your totals don’t match up with the values in the table. Take this example, counting the number of users who purchased items over a 6 week period:

 ![Screenshot 2024-05-30 at 3.30.02 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/cf5a7a3b5a7ed8a77325ca8bcaed3284daf8ec76.png)

If you sum up the 6 rows, you’d get 11,143 - but our column total is returning 10,884.

This occurs because Omni totals ensure uniqueness - only 10,884 unique user IDs exist here (which we can see if we remove the grouping by week), some users have simply placed multiple orders across this timeframe.

 ![Screenshot 2024-05-30 at 3.32.42 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/10765eb865f84650788fe385fb1799e97f3b65f0.png)

You will see the same thing on all aggregate types using Omni’s native column and row totals - something like an average is a little trickier to think about, but the principal is the same - rather than taking average weekly average, Omni is taking the overall average margin per item here.

 ![Screenshot 2024-05-30 at 3.34.38 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/d5b93a15f44f8433f4a7b3ce98c4d8ff0432ea2a.png)

In cases where you’re looking to actually sum these values and make them non-distinct (which we see relatively rarely), hover over the 3 dot menu on the right side of the cell of the total you’d like to change, and you can swap to a naive total.

 ![Screenshot 2025-10-02 at 9.00.55 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/e2f171c4d6b2bdf69729a97c8ef1be0df50bffb3.jpeg)