PivotTables / PivotChart, showing data for a value that could be in 1 or 2 columns

[BassettN]

Good morning,

I am working on preparing a scorecard for our team, and what I want to create is a dashboard where we can select a user via a drop down, and it will update the scorecard for that user.

There are 3 data points that we are looking at for performance: 1) Cycle time 2) External quality and 3) Internal quality. I have a slicer for internal quality and external quality (both are # of errors), a timeline that is connected to all 3 pivots, and those are easy enough. If I add the cycle time pivot as a connection on the Documenter/Reviewer slicers, when I select the user's name on both slicers, it will only show me data for rows that they fit both criteria, which is rare.

What I am trying to accomplish is for cycle time to see any deal they were a part of, whether they were a documenter or reviewer, and have the cycle time graph show the average time of any deal that they were working. Below is a sample of the data I am working with.

Is what I am trying to do impossible? If it is possible, I am not looking for the full solution (as I want to do the work), I just need a general direction of how to accomplish this.

[TABLE="width: 838"] <tbody>[TR] [TD="align: left"]Affiliate[/TD] [TD="align: left"]Credit Lead #[/TD] [TD="align: left"]Documenter Name[/TD] [TD="align: left"]Reviewer Name[/TD] [TD="align: left"]Cycle Time[/TD] [TD="align: left"]# of Internal Errors[/TD] [TD="align: left"]# of External Errors[/TD] [/TR] [TR] [TD="align: left"]FFF[/TD] [TD="align: left"]2484[/TD] [TD="align: left"]Pam[/TD] [TD="align: left"]Pam[/TD] [TD="align: right"]2:31:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]EEE[/TD] [TD="align: left"]2480[/TD] [TD="align: left"]Vanessa[/TD] [TD="align: left"]Jennifer[/TD] [TD="align: right"]1:44:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]DDD[/TD] [TD="align: left"]2477[/TD] [TD="align: left"]Ryan[/TD] [TD="align: left"]Vanessa[/TD] [TD="align: right"]2:40:00[/TD] [TD="align: right"]1[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]EEE[/TD] [TD="align: left"]2476[/TD] [TD="align: left"]Jennifer[/TD] [TD="align: left"]Anna[/TD] [TD="align: right"]0:45:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]EEE[/TD] [TD="align: left"]2473[/TD] [TD="align: left"]Anna[/TD] [TD="align: left"]Pam[/TD] [TD="align: right"]4:18:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]FFF[/TD] [TD="align: left"]2470[/TD] [TD="align: left"]Oscar[/TD] [TD="align: left"]Dwight[/TD] [TD="align: right"]6:37:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]AAA[/TD] [TD="align: left"]2465[/TD] [TD="align: left"]Ryan[/TD] [TD="align: left"]James[/TD] [TD="align: right"]5:40:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]AAA[/TD] [TD="align: left"]2463[/TD] [TD="align: left"]David[/TD] [TD="align: left"]Vanessa[/TD] [TD="align: right"]6:45:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]AAA[/TD] [TD="align: left"]2462[/TD] [TD="align: left"]Vanessa[/TD] [TD="align: left"]Sam[/TD] [TD="align: right"]8:20:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]CCC[/TD] [TD="align: left"]2461[/TD] [TD="align: left"]Meredith[/TD] [TD="align: left"]Vanessa[/TD] [TD="align: right"]5:51:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] [TR] [TD="align: left"]CCC[/TD] [TD="align: left"]2460[/TD] [TD="align: left"]David[/TD] [TD="align: left"]Vanessa[/TD] [TD="align: right"]5:35:00[/TD] [TD="align: right"]0[/TD] [TD="align: right"]0[/TD] [/TR] </tbody>[/TABLE]

<tbody> </tbody>