Prev: printing issue
Next: Create IT diagrams in MS Visio and simplify processes
From: TRAlbert on 9 Dec 2009 22:23
I'm using MS Project 2007, have input all my tasks, costs, set baseline so
all my numbers are populating great.

I'm using the visual report to generate the earned value over time report
(the pivot table and chart). Unfortunately while I am really good at most
things Excel, pivot tables is not one of them. Project is populating the
table with Quarters 1, 2 and 3. I only need Quarter 1 for my report. Is there
a way to hide or delete the other two quarters from the table?

Thanks for the help!
Teri
From: JulieS on 10 Dec 2009 10:19
Hi Teri,

I am guessing that you have your "Time Weekly Calendar" or "Time
Monthly Calendar" in the Row labels section of the pivot table. In
the pivot table, click the drop-down at the top of the "year"
heading and you should see value filters. Uncheck the "Select all",
expand the list and then click the quarters you wish to see.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project


"TRAlbert" <TRAlbert(a)discussions.microsoft.com> wrote in message
news:6E108E3A-825D-479D-95D1-13F3B3D7F27A(a)microsoft.com...
> I'm using MS Project 2007, have input all my tasks, costs, set
> baseline so
> all my numbers are populating great.
>
> I'm using the visual report to generate the earned value over time
> report
> (the pivot table and chart). Unfortunately while I am really good
> at most
> things Excel, pivot tables is not one of them. Project is
> populating the
> table with Quarters 1, 2 and 3. I only need Quarter 1 for my
> report. Is there
> a way to hide or delete the other two quarters from the table?
>
> Thanks for the help!
> Teri


 | 
Pages: 1
Prev: printing issue
Next: Create IT diagrams in MS Visio and simplify processes