[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Suarez, Ross, C,27940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Garcia, Ryan, J,15692 | 8392.30 | 0.00 | 3578.27 | 0.00 | 4814.03 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Serrano, Frank,23232 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Johnsen, Rebekah, J,19919 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ward, Alex, I,14542 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Suarez, Kristine,16282 | 64.25 | 0.00 | 0.00 | 0.00 | 64.25 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Yuan, Omar, C,12380 | 5570.22 | 0.00 | 0.00 | 2049.10 | 3521.12 |
| Chandra, Regina, M,15057 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Washington, Julia, R,20875 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Roberts, Gabrielle, E,29432 | 1307.31 | 0.00 | 0.00 | 0.00 | 1307.31 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Martinez, Deanna,17202 | 6974.06 | 0.00 | 0.00 | 2181.56 | 4792.50 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Huang, Todd,12463 | 5202.22 | 0.00 | 0.00 | 2071.42 | 3130.80 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Tang, Gregory,24048 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 47.97 | 0.00 |
| Rai, Kristin, C,12569 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Rodriguez, Gerald,12216 | 6955.41 | 0.00 | 0.00 | 2071.42 | 4883.99 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Kumar, Arturo, W,24044 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Bell, Haley, A,29437 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 78.98 | 28.99 |
| Kelly, Richard,17991 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Lu, Clayton, L,23613 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hu, Curtis, G,27880 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Alonso, Tanya, K,26942 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 8.99 | 36.27 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Phillips, Gabriel, R,29443 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Prasad, Jillian,12860 | 4464.09 | 0.00 | 0.00 | 2049.10 | 2414.99 |
| Beck, Damien, E,23989 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Subram, Allen,17895 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 1188.46 | 0.00 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Garcia, Francisco,25701 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Malhotra, Ruth, D,16321 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Butler, Natalie,26401 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Garcia, Marie,27953 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Hughes, Adam,24546 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 67.46 | 0.00 |
| Zhang, Cedric, D,26966 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Fernandez, Dominic,23630 | 2481.82 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Jiménez, Derrick, B,17890 | 2753.52 | 0.00 | 0.00 | 2181.56 | 571.96 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ye, Sandra,24689 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2822.76 | 2338.97 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Tang, Tonya,20917 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Edwards, Edward,14700 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2849.41 | 2405.47 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Deng, Tonya, O,17936 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Alonso, Arthur, M,19054 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Muñoz, Dana,28459 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chow, Jamie,27815 | 110.46 | 0.00 | 0.00 | 110.46 | 0.00 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Jai, Kelsey, J,27837 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Romero, Teresa, A,26834 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Subram, Mayra, C,28446 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Patterson, Jessica,17182 | 6950.60 | 0.00 | 0.00 | 2181.56 | 4769.04 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Tang, Casey,15046 | 5943.25 | 0.00 | 3578.27 | 0.00 | 2364.98 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Martin, Joy, L,13544 | 108.44 | 0.00 | 0.00 | 0.00 | 108.44 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 1000.44 | 0.00 | 636.94 |
| Jai, Terrence,27956 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Randall, Kristi,13665 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Suri, Brenda, D,22643 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Parker, Eric, H,27130 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 118.96 | 71.58 |
| Alonso, Micheal, W,19307 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 583.97 | 0.00 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 2049.10 | 0.00 | 4754.82 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2024-11-10 13:10:22.119 UTC