Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Subtotal Bar to show different resources

3 replies [Last post]
Wed, 2006-06-21 20:34
Alan Lee
User offline. Last seen 18 years 30 weeks ago. Offline
Joined: 16 May 2006
Posts: 4
Groups: None
Hi,

I have a subtotal bar at the top of my schedule to show the total of the budgets, but i would like to show the subtotals of each resource individually, since the subtotal adds the budgeted quanity of each task which is not what i want as i would like to see the total of individual resources, is this possible?

also i do not want to group by resources since i would like to show the tasks in a specific grouping
Top

Replies

Fri, 2006-06-23 17:33
#1
Jaime Linchangco
User offline. Last seen 15 years 46 weeks ago. Offline
Joined: 16 Jul 2001
Posts: 29
Groups: None
Hi Alan!

Good day! Yes, it is possible.

One way is defining resources under custom data items’ Resource/Cost and running Global change. But there’s the limitation on the numbers of resources only.

Example, You have a resources named "MELEC", define under custom data items an equivalent name "ELEC" , "N" Numeric and 4 for Length with description "Electrical Work. Continue defining all other equivalent resources.

Then, in Global Change, add a new one. Under Change Specification, write something like this,

If RES EQ MELEC
Then ELEC EQ BQ

Run the Global Change and continue doing with all other resources with equivalent custom data item.

Lastly, you could now show under column each Budget Quantity for each custom defined resources complete with Sub total.

Good luck

Jaime

Top
Thu, 2006-06-22 07:51
#2
Nigel Winkley
User offline. Last seen 42 weeks 1 day ago. Offline
Joined: 11 May 2006
Posts: 187
Groups: The GrapeVine
Alan

It’s one of the failings of P3. If, for example, you have resources of square metres, cubic metres, linear metres, man hours and number of...P3 adds them all together to give you a sub-total meaning absolutely nothing!

As the earlier answer, use a report.

Cheers

Nige
Top
Wed, 2006-06-21 22:53
#3
Zhang Haixiang
User offline. Last seen 4 years 17 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
You can not do this in P3 layout.
You can do this by report or other tools (e.g. informaker,Access...)
Top