I'm trying to create a dashboard for our Sales Reps that will pull information from a PivotTable.
Here is an example of the Dashboard:
Here is an example of the Pivot Table:
In the Dashboard, the Month (Apr) will change based on a dropdown. What I would like is for it to look for Jazmin Martinez on the RepPivot Tab, then look at Apr (this month could change), and put bring across the sales number for that month. Is that possible?
Here is an example of the Dashboard:
Apr | |||
Sales Rep | Total Bookings | ICA Bookings | |
Jazmin Martinez | |||
Jim LaGrou | |||
John O'Neal | |||
Karolyn Gibbs | |||
Marty Mikulenka | |||
Valerie Jopling | |||
Here is an example of the Pivot Table:
Combined Commission Log - FY24 Booked.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Quarter | Q1 | |||||
2 | Bucket | (All) | |||||
3 | |||||||
4 | Sum of Board Credit | Column Labels | |||||
5 | Row Labels | Feb | Mar | Apr | Grand Total | ||
6 | Bill Valenta | $ 11,072 | $ 46,639 | $ 35,296 | $ 93,008 | ||
7 | Brandon Robertson | $ 10,737 | $ 7,242 | $ 22,364 | $ 40,343 | ||
8 | Brian Dykhuizen | $ 15,393 | $ 39,261 | $ 54,654 | |||
9 | Bryan Schweet | $ 94,538 | $ 347,827 | $ 10,660 | $ 453,025 | ||
10 | Bryce Conley | $ 11,695 | $ 20,634 | $ 32,329 | |||
11 | Cameron Looney | $ 32,745 | $ 16,348 | $ 271,766 | $ 320,859 | ||
12 | Chase Chapman | $ 57,175 | $ 60,621 | $ 46,297 | $ 164,093 | ||
13 | Christopher Parnell | $ 89,061 | $ 7,425 | $ 69,016 | $ 165,502 | ||
14 | Connor Bilancio | $ 395,683 | $ 39,396 | $ 20,339 | $ 455,418 | ||
15 | Danielle Mitchell | $ 17,836 | $ 15,272 | $ 3,992 | $ 37,100 | ||
16 | Dean Diroff | $ 55,014 | $ - | $ 10,773 | $ 65,787 | ||
17 | Dennis Mosley | $ 45,517 | $ 7,907 | $ 72,075 | $ 125,498 | ||
18 | Douglas Foulsham | $ 21,487 | $ 23,342 | $ 44,829 | |||
19 | Eddie Lopez | $ 138,034 | $ 44,737 | $ 117,365 | $ 300,136 | ||
20 | Eric Delphia | $ 115,133 | $ 86,009 | $ 201,142 | |||
21 | Felicia Pope | $ 70,661 | $ 70,661 | ||||
22 | Francis Ambrose | $ 42,207 | $ 42,275 | $ 84,482 | |||
23 | Frank Stauersboll | $ 7,830 | $ 33,213 | $ 40,340 | $ 81,383 | ||
24 | Incoming Split | $ 10,125 | $ 9,665 | $ 71,152 | $ 90,942 | ||
25 | Jake Hunter | $ 12,986 | $ 8,367 | $ 21,353 | |||
26 | Jake Kleine | $ 54,167 | $ 67,169 | $ 20,970 | $ 142,306 | ||
27 | Jake Stacey | $ 48,964 | $ 52,837 | $ 15,105 | $ 116,906 | ||
28 | Jazmin Martinez | $ 10,470 | $ 32,090 | $ 19,706 | $ 62,266 | ||
29 | Jim LaGrou | $ 9,282 | $ 37,896 | $ 47,178 | |||
RepPivot |
In the Dashboard, the Month (Apr) will change based on a dropdown. What I would like is for it to look for Jazmin Martinez on the RepPivot Tab, then look at Apr (this month could change), and put bring across the sales number for that month. Is that possible?