locked
Sum in powerpivot RRS feed

  • Question

  • Hello!

    I have 2 columns, Hour and Project.

    Project             Hour

    GXXXXX            12

    GXXXXX            34

    GXXXXX            65

    JXXXXX             11

    JXXXXX             54

    JXXXXX             45

    I want to get a SUM for every project, G is one project and J another.

    For example

    GXXXXX            111

    JXXXXX             110

    Anyone got any good ideas? =)

    Tuesday, July 24, 2012 7:49 AM

Answers

  • Hi there,

    Add in a calculated column =Left([Project],1) called ProjectPrefix (or something).

    Add a measure called Total Hours:= SUM([Hour])

    You should then be able to roll up your values by the first letter of the project code.

    cheers,

    Andrew


    Andrew Sears, T4G Limited, http://www.performancepointing.com

    • Proposed as answer by Elvis Long Thursday, July 26, 2012 10:34 AM
    • Marked as answer by rule.z.z Monday, July 30, 2012 9:08 AM
    Wednesday, July 25, 2012 3:28 PM

All replies

  • Hi there,

    Add in a calculated column =Left([Project],1) called ProjectPrefix (or something).

    Add a measure called Total Hours:= SUM([Hour])

    You should then be able to roll up your values by the first letter of the project code.

    cheers,

    Andrew


    Andrew Sears, T4G Limited, http://www.performancepointing.com

    • Proposed as answer by Elvis Long Thursday, July 26, 2012 10:34 AM
    • Marked as answer by rule.z.z Monday, July 30, 2012 9:08 AM
    Wednesday, July 25, 2012 3:28 PM
  • Hi,

    Im wondering how you would do this if you didnt want to use the measure tool. Im looking to sum the hours for projects just like the OT, but I want to then be able to use the "sum of hours" column inside the PowerPivot window to create another display.

    Any suggestions?

    Monday, July 30, 2012 7:35 AM