Basic combined table RRS feed

  • Question

  • So Im trying to make a table that shows workload (man-months) per month (and year).

    I have an excel document which in I have Workprocess, start, end, and workload estimate (man-months).

    Dates like start are in format 12.12.2012.

    I need to make another workbook that shows Months and Workload per month (which means the whole workload of all processes for that month combined). If I changed process duration or workload, they would dynamically change in the other workbook too.

    Im a beginner but this should be possible to do with Get & Transform right? All advice is much appreciated.

    Monday, May 21, 2018 9:53 AM