# Pivot table not displaying a column in report, but does in chart and export

**URL:** <https://community.spicecrm.io/t/pivot-table-not-displaying-a-column-in-report-but-does-in-chart-and-export/438>\
**Category:** KReporter\
**Created:** [March 28, 2019, 1:14pm UTC](https://community.spicecrm.io/t/pivot-table-not-displaying-a-column-in-report-but-does-in-chart-and-export/438 "2019-03-28T13:14:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tessupport](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@tessupport](https://community.spicecrm.io/u/tessupport)\
**Post date:** [March 28, 2019, 1:14pm UTC](https://community.spicecrm.io/t/pivot-table-not-displaying-a-column-in-report-but-does-in-chart-and-export/438/1 "2019-03-28T13:14:46Z")

</div>

Hello,

We have an Invoice YTD repot by Business Type (renewal, growth, new business, other). When we run the report, only 3 of the 4 columns appear in the report (renewal, growth and other [blank]). The chart shows all 4 categories and when exported to excel, all 4 categories appear. Any idea why this happens?

Thank you

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [March 29, 2019, 8:42am UTC](https://community.spicecrm.io/t/pivot-table-not-displaying-a-column-in-report-but-does-in-chart-and-export/438/2 "2019-03-29T08:42:49Z")

</div>

Do you have empty values for new business? =\> no invoices

---

<div class="post-metadata">

**Author:** ![tessupport](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@tessupport](https://community.spicecrm.io/u/tessupport)\
**Post date:** [April 2, 2019, 1:54pm UTC](https://community.spicecrm.io/t/pivot-table-not-displaying-a-column-in-report-but-does-in-chart-and-export/438/3 "2019-04-02T13:54:20Z")

</div>

if I understand you correctly, there are contracts that are not new business?

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [April 2, 2019, 8:28pm UTC](https://community.spicecrm.io/t/pivot-table-not-displaying-a-column-in-report-but-does-in-chart-and-export/438/4 "2019-04-02T20:28:32Z")

</div>

Difficult to say without seeing anything.  
There is a ‘show empty values’ for pivot table if I recall correctly. Did you check it?