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

BassettN

New Member
Joined
Apr 8, 2019
Messages
7
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"]
Code:
[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]
[/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,223,247
Messages
6,171,007
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top