# Pivot table row overall totals do not handle null values

**URL:** https://community.holistics.io/t/pivot-table-row-overall-totals-do-not-handle-null-values/2332
**Category:** Ask the Community
**Created:** [December 13, 2024, 11:40am UTC](https://community.holistics.io/t/pivot-table-row-overall-totals-do-not-handle-null-values/2332 "2024-12-13T11:40:56Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![py1209](https://community.holistics.io/user_avatar/community.holistics.io/py1209/32/2113_2.png) [@py1209](https://community.holistics.io/u/py1209)
#### Post date: [December 13, 2024, 11:40am UTC](https://community.holistics.io/t/pivot-table-row-overall-totals-do-not-handle-null-values/2332/1 "2024-12-13T11:40:56Z")

</div>

besides modifying the sql query table code to insert a 0 if null - is there a way to bypass this?

---

<div class="post-metadata">

### Author: ![Theodore](https://community.holistics.io/user_avatar/community.holistics.io/theodore/32/832_2.png) [@Theodore](https://community.holistics.io/u/Theodore)
#### Post date: [December 16, 2024, 4:00am UTC](https://community.holistics.io/t/pivot-table-row-overall-totals-do-not-handle-null-values/2332/2 "2024-12-16T04:00:56Z")

</div>

Hi @py1209,

Could you please share your expected results and the reasons for wanting to replace null values with zeros? It’d be great to understand your needs better so I can find the best way to help you out.