Resource Work not filtering RRS feed

  • Question

  • I have a BI report I am drafting which is attempting to show the split of resource work across time. I have a resource custom field which when I filter by I get the resource capacity filtered ok but the work value remains the same irrespective of which filter I apply.  How do I get the work value to be filtered to the amount of work the resource has been assigned to?



    Thursday, April 30, 2015 3:37 PM

All replies

  • Hi Stev,

    Could you provide further below information so that we can help you - 

    1. Is it SSRS, OData or any other report?

    2. Is you environment project server 2010, 2013 or Project Online?

    3. Could you share your report query details and share an example what are you getting now and trying to achieve?

    Cheers, Badal

    • Edited by Badal Ratra Thursday, April 30, 2015 10:48 PM
    Thursday, April 30, 2015 10:48 PM
  • Hi it is an Excel Services Pivot Chart and table. I have created 2 identical copies of the chart.  I then filter one for Resource Name A and the other for Resource Name B.   For the Capacity value I get different amounts which is what I would expect for the different resources, for the Work value I get the same amount irrespective of which Resource I filter for.  How do I get the work amount to filter to only be the assigned work against the filtered resource?



    Tuesday, May 5, 2015 10:21 AM