Posted on Friday, 18th November 2011 by scaywood
Dumping Expenses to Excel and Filtering by year.
Being able to manipulate P6 data in Excel can sometimes be helpful. Here is a case where I copied expenses from Primavera P6 and pasted them into Excel to filter out a certain year’s data.
1. In the Expense view, type Ctrl A to select all
a. Right click and choose Copy
2. In Excel, right click and choose Paste
3. Select the top row containing the column titles, Row 1
a. Select the AZ funnel icon, then Filter
4. Select the Fiscal Year drop down arrow and select the year you would like to see data on:
5. Now data from only 2011 is selected:
Tags: CBA, Oracle, P6, Primavera, Project Scheduling, Training
Posted in P6, P6: Web, Project Management, Tips & Tricks, Training | Comments (0)
