Filter in MSP

Microsoft Project
J
jatin mamman 👤 Member for 20 years 4 months
· Permalink

Thank you sir,



Seems my work wont cut out so easily,

Will have to take the longer route





Cheers

Jatin

Z
Zhang Haixiang 👤 Member for 21 years 2 months
· Permalink

It’s not so easy to do this.



1. If the resource for the task is work ( not material) and the task has only one resource ( or has several resource, but you do not want to know the value for each resource) then you can try ’analyze timescaled date in excel’ It’s on the ’analysis’ tool bar. if you can not see it, right click on the tool bar,then check it.



Follow the instruction, then you will get a excel sheet. you can have planned work for every day(or week, month...) for each task.



2.if your resource is material or you have more than 1 resource for each task and want to have the value for each resource.

change to ’task usage’view, then use copy & paste to transfer all the data to excel, you will get a sheet with planned work for each resource and task



hope this helps

J
jatin mamman 👤 Member for 20 years 4 months
· Permalink

hi



Ok, My problem is: For a particular Task - I want to know the Percentage of Works Planned in a particular month, I have the Quantity for the Task and the Rate, from which I will get the Amount.

So Getting the percentage of works planned for the required month will give me the exact Budgeted Amount for the particular month.



So can I use Filters to get the percentage of works planned for the required month and get the correct Budgeted Amount or is there a better way?



Cheers

Jatin

Z
Zhang Haixiang 👤 Member for 21 years 2 months
· Permalink

I mean you can not show part of a task.

You can scroll the timesacle,so you can alway see the end of the task, even the task last for years.

Z
Zhang Haixiang 👤 Member for 21 years 2 months
· Permalink

A filter only picks up those tasks meet certain Criteria then show them on the screen.



there are only two option show or not show.

Once the task is shown on screen, then you can access all information of this task e.g. finish date, % complete, resource, cost...

there’s nothing to do with % planned work.(no such a field in MSP)



So for your example, you want to show the activity or not?

Forum Sponsor

Top Posters

Soheil Barekat
4 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts