ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is this possible? (https://www.excelbanter.com/excel-programming/283798-possible.html)

Matt Elms

Is this possible?
 
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




Debra Dalgleish

Is this possible?
 
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.

Matt Elms wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com