Is this possible?

  • Thread starter Thread starter Matt Elms
  • Start date Start date
M

Matt Elms

I wonder if anyone could help me?
In my excel file I have two workbooks. One workbook with data (production
schedule) and in the other workbook I have a pivot table to list jobs
delivered by customer name. What I would like to do is to report the data
between two date ranges in the pivot table. At this moment in time I only
have the option to choose a specific date or all.
Thanks
Matt Elms
 
One way to do this is to drag the Date field to the Row area.
Right-click on the Date field button, and choose
Group and Show Detail> Group
Enter a Start and End date, and click OK
From the Date field dropdown list, remove the check mark for
the first item, which should be <[your start date]
Drag the Date field back to the Page area.
 
Back
Top