Skip to content

Subtotal Bar to show different resources

Alan LeeMember for 20 years 5 months
Created
3
1
0
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

3 replies

Oldest first
  1. 0
    Zhang Haixiang ·
    You can not do this in P3 layout.
    You can do this by report or other tools (e.g. informaker,Access...)
  2. 0
    Nigel Winkley ·
    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
  3. 0
    Jaime Linchangco ·
    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?