| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Does Not Show Data | Excel Discussion (Misc queries) | |||
| Pivot Table- Show Data % of | Excel Discussion (Misc queries) | |||
| Show all data in pivot table | Excel Discussion (Misc queries) | |||
| show sereral columns of data field in pivot table | New Users to Excel | |||
| add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Linear Mode
