Sometimes you'll want to get the oldest or newest activity out of Projector reports. By default, Projector dates are typically treated as a column field in Excel. That means they are used to categorize things like hours into columns. But we can turn dates into Value fields and apply Min or Max to get oldest and most recent dates. For example, you might want to know the last month a resource was ever scheduled. This page will show you how. Tip - if you are looking at Actuals data and are interested in day level granularity, then some reports have a row field called Work Date. This will be a time card's work date. By using this row field here rather than a column field, you can avoid the annoying popup messages about adding items to the pivot table. |
Follow these steps: