# How do I add a row with column totals to my query?

**URL:** <https://community.omni.co/t/how-do-i-add-a-row-with-column-totals-to-my-query/86>\
**Category:** Workbooks\
**Created:** [May 31, 2024, 7:15pm UTC](https://community.omni.co/t/how-do-i-add-a-row-with-column-totals-to-my-query/86 "2024-05-31T19:15:25Z")\
**Posts on this page:** 2\
**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, 7:15pm UTC](https://community.omni.co/t/how-do-i-add-a-row-with-column-totals-to-my-query/86/1 "2024-05-31T19:15:25Z")

</div>

Row totals and column totals are available in the options menu in the Results tab (rather than the Chart tab).

If your row/column totals don’t match the values you were expecting, check out [this article](https://community.omni.co/t/why-dont-my-column-row-totals-match-the-values-in-the-table/82) to troubleshoot.

---

<div class="post-metadata">

**Author:** ![liam](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/liam/32/178_2.png) [@liam](https://community.omni.co/u/liam)\
**Post date:** [September 23, 2024, 5:15pm UTC](https://community.omni.co/t/how-do-i-add-a-row-with-column-totals-to-my-query/86/2 "2024-09-23T17:15:20Z")

</div>

If you need to do a row total in the calculation, then you can use the forumla `=SUM(PIVOTOFFSET(B1, 0, 0, 1, 5000))`, which will sum all of the values in B1, from column 1 to column 5000.