show all years in pivot table

  • Thread starter Thread starter Rich Rath
  • Start date Start date
R

Rich Rath

Data in Access is in field called year, with value for
years ranging from 1704 to 1783. Not every year is
represented. Is there a way to make the pivot table show
every year in the series even though there is no year in
the underlying data? E.g., the actual data look like
this: 1704, 1704, 1705, 1707, 1707, 1707, 1708. Is there
a way to show an empty 1706? Show empty cells won't do
it because there are no cells for the missing years.
Thanks!
Rich Rath
 
Hi
AFAIK this is not possible if these dates are not in your range
 
And in addition, Excel doesn't recognize dates prior to 1900, so it's not
possible to construct a range of DATES that includes these years. Text is
another matter, however.
 
You must log in or register to reply here.

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

pivot table 5
Show Pivot Table Dates in a Month/Year Linear Fashion 2
Pivot table problem 4
pivot table - show ALL detail? 3
Show me your highest mileage HDD? 0
Pivot Table - Show difference 6
Pivot Table Count Issue 6
Query Development 7

Back
Top