< and > not showing in pivot table

  • Thread starter Thread starter Reds
  • Start date Start date
R

Reds

I have created a pivot table placing a date field in the column box.
have given a date range to display (5/1/2004-12/31/2005). All of th
months within this range are displaying fine but I also need a colum
for the <5/1/2004 and >12/31/2005. These show up under th
PivotTableField popup in the Hide Items box but even though they ar
not highlighted they don't show up on the table. I am running Offic
97. Any help would be appreciate
 
Is there data for those date ranges for the selected row fields?
 
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 and value range 2
Grouping Time in Pivots. 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table lookup 1
Pivot tables - adding dates, descriptions 1
Excel Pivot Table VB Code 1
Pivot Table help! 9
Rank items in Pivot Table 3

Back
Top