Problem with PivotTable respecting relationship RRS feed

  • Question

  • I have a very simple PowerPivot workbook where I imported Project data from a SQL table and Issues data from a SharePoint list.  Both tables in PowerPivot have ProjectUID and I created a relationship.  For some reason, when I createa PivotTable, all Issues show for all Projects.  The PivotTable should only show the issues for a particular project. 

    What am I doing wrong?  Here is a snapshot of the PivotTable and the Desired Result:

    Thursday, March 8, 2012 6:28 PM


  • Thanks.  I ended up having to add a measure to the Values area of my PivotTable and everything worked fine.  In my case, I used "Issue ID" for a count on Issues.
    Thursday, March 8, 2012 11:12 PM

All replies