ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Table: Show columns with no data (https://www.excelbanter.com/excel-programming/303150-pivot-table-show-columns-no-data.html)

john

Pivot Table: Show columns with no data
 
I am using a pivot table to create an AR aging report with
30, 60, 90, 90+ columns as data items. My problem is that
when I pull up a customer that has invoices that are only
30 days past due, only the 30 column shows up and not the
rest (60, 90, 90+). How do I force the pivot table to
show the columns with nothing?

Want this...
30 60 90 90+
ABC Inc $10

Getting this...
30
ABC Inc $10




All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com