Spreadsheet: 686469d1594648117-identifying-top-vendors-who-contribute-to-refunds-and-top-70-items-for-refunds-power-pivot-sample-data2
Sheet: Main Sheet 

itemid | [NAME] | TicketReason | Refunds
6825 | sirsara | Backorder | 210
2565 | silocha | Pre-Sell | 4500
2678 | vimosa | Order Issues | 3383
4748 | silocha | Buyer's Remorse | 2062
5336 | dconcr | Order Issues | 4625
3628 | silocha | Pre-Sell | 3392
4750 | vimosa | Order Issues | 5785
8004 | silocha | Pre-Sell | 3374
8570 | vimosa | Backorder | 2915
3856 | lilosale | Backorder | 6762
8094 | silocha | Pre-Sell | 5849
6566 | sirsara | Backorder | 5856
5635 | vimosa | Order Issues | 4758
1886 | circarch | Order Issues | 3251
3239 | nidos | Chargeback | 5427
7639 | sirsara | Backorder | 6067
3811 | sirsara | Backorder | 2091
3571 | sirsara | Backorder | 5001
8839 | vimosa | Backorder | 5456
2783 | Furinno | Order Issues | 2816
2478 | circarch | Backorder | 2718
8118 | silocha | Pre-Sell | 4442
1944 | vimosa | Buyer's Remorse | 1179
5882 | glytic | Buyer's Remorse | 5300
957 | vimosa | Buyer's Remorse | 1077
2369 | sirsara | Backorder | 5140
4771 | dinos | Order Issues | 4784
6549 | sirsara | Backorder | 6898
6191 | vimosa | Buyer's Remorse | 1047
4959 | vimosa | Pre-Sell | 2090
6587 | vimosa | Order Issues | 1527
6331 | vimosa | Order Issues | 4039
4014 | vimosa | Order Issues | 1340
6603 | Furinno | Order Issues | 2557
6675 | [NAME] | Pre-Sell | 1713
8913 | vimosa | Pre-Sell | 2515
1705 | vimosa | Pre-Sell | 3444
7213 | vimosa | Pre-Sell | 5536
6849 | vimosa | Pre-Sell | 6578
8047 | vimosa | Pre-Sell | 2549
5090 | simsa | Pre-Sell | 5765
1218 | vimosa | Pre-Sell | 5977
3507 | vimosa | Pre-Sell | 1517
2991 | vimosa | Pre-Sell | 5622
3190 | vimosa | Pre-Sell | 5237
2196 | vimosa | Pre-Sell | 5033
6900 | vimosa | Pre-Sell | 3266
3079 | vimosa | Pre-Sell | 4776
8361 | vimosa | Pre-Sell | 1000
7475 | vimosa | Pre-Sell | 6808
 |  |  |  |  | To Sort: go to figure and Hit the Descending button (off the data menu  z--> a)
 |  |  |  |  | top 5 is a selection from Pivot table Options
 |  |  |  |  | Top 5 |  |  | Top 5
 |  |  |  |  | TicketReason | Backorder |  | TicketReason | Pre-Sell |  | TicketReason | Pre-Sell |  | TicketReason | Backorder
 |  |  |  |  | Row Labels | Sum of Refunds |  | Row Labels | Sum of Refunds |  | Sum of Refunds |  |  |  | Values
 |  |  |  |  | sirsara | 31263 |  | vimosa | 61948 |  | itemid | Total |  | itemid | Count of Refunds | Sum of Refunds 2
 |  |  |  |  | vimosa | 8371 |  | silocha | 21557 |  | 7475 | 6808 |  | 6549 | 1 | 6898
 |  |  |  |  | lilosale | 6762 |  | simsa | 5765 |  | 6849 | 6578 |  | 3856 | 1 | 6762
 |  |  |  |  | circarch | 2718 |  | [NAME] | 1713 |  | 1218 | 5977 |  | 7639 | 1 | 6067
 |  |  |  |  | Grand Total | 49114 |  | Grand Total | 90983 |  | 8094 | 5849 |  | 6566 | 1 | 5856
 |  |  |  |  |  |  |  |  |  |  | 5090 | 5765 |  | 8839 | 1 | 5456
 |  |  |  |  |  |  |  |  |  |  | 2991 | 5622 |  | 2369 | 1 | 5140
 |  |  |  |  |  |  |  |  |  |  | 7213 | 5536 |  | 3571 | 1 | 5001
 |  |  |  |  |  |  |  |  |  |  | 3190 | 5237 |  | 8570 | 1 | 2915
 |  |  |  |  |  |  |  |  |  |  | 2196 | 5033 |  | 2478 | 1 | 2718
 |  |  |  |  |  |  |  |  |  |  | 3079 | 4776 |  | 3811 | 1 | 2091
 |  |  |  |  |  |  |  |  |  |  | 2565 | 4500 |  | 6825 | 1 | 210
 |  |  |  |  |  |  |  |  |  |  | 8118 | 4442 |  | Grand Total | 11 | 49114
 |  |  |  |  |  |  |  |  |  |  | 1705 | 3444
 |  |  |  |  |  |  |  |  |  |  | 3628 | 3392
 |  |  |  |  |  |  |  |  |  |  | 8004 | 3374
 |  |  |  |  |  |  |  |  |  |  | 6900 | 3266
 |  |  |  |  |  |  |  |  |  |  | 8047 | 2549
 |  |  |  |  |  |  |  |  |  |  | 8913 | 2515
 |  |  |  |  |  |  |  |  |  |  | 4959 | 2090
 |  |  |  |  |  |  |  |  |  |  | 6675 | 1713
 |  |  |  |  |  |  |  |  |  |  | 3507 | 1517
 |  |  |  |  |  |  |  |  |  |  | 8361 | 1000
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 90983