how to show years with no data attached in excel 2007?

G

Guest

In a pivot table attached to an access database. The database contains
fields for year and for another feature. I want to display the count of the
other feature per year for a range of years in an excel pivot table. Some of
the years have no data attached to them, but I want all the years in the
range to show, even if there is no data for that year. I have been unable to
figure out how to do this in excel.
 
D

Debra Dalgleish

Unless there's at least one record for the year, it won't appear in the
pivot table. Perhaps you can add a dummy record to the database for the
years with no data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Years in a Pivot table 2
Limit using pivot table with Access database? 1
Arrange B values ascending order but keep attached to column A in. 1
Pivot Tables 4
show all years in pivot table 2
Pivot Table Fiscal Years 1
Hello happy new year to all, Text box input for year of purchase 0
pivot table excel 2007 -- show rows with no data 1

Top