[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 120 >
120 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Rachael, M,22535 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Malhotra, Dominique,12460 | 5678.91 | 0.00 | 0.00 | 2049.10 | 3629.81 |
| Suarez, Larry, D,28694 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Yang, Kelvin,13404 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| James, Charles,28523 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Russell, Emma, I,21512 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Price, Brittany,12492 | 5166.41 | 0.00 | 0.00 | 2049.10 | 3117.31 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Morris, Jacqueline, H,29468 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Lal, Ashlee, A,28417 | 2426.00 | 0.00 | 0.00 | 0.00 | 2426.00 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Powell, Gavin, M,28530 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Subram, Holly, J,28552 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gill, Krista,12664 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Tang, Carly, A,22470 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Smith, Jasmine,28891 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Wright, Logan, M,13783 | 5955.23 | 0.00 | 3578.27 | 0.00 | 2376.96 |
| Zhao, Edwin,14991 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Browning, Carrie, G,19299 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Zhao, Colleen, L,16407 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 2049.10 | 3671.27 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| He, Jenny, C,24100 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Shan, Lindsay,27186 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Torres, Marvin, J,27885 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| Kumar, Peter,26915 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Perez, Holly, E,12376 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Sara, Evelyn,16045 | 3802.37 | 0.00 | 2181.56 | 0.00 | 1620.81 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 0.00 | 134.95 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Kelly, Marcus, A,25699 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Nelson, Luke, E,21027 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Xu, Shaun, N,27804 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Vazquez, Michele,16934 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 0.00 | 190.54 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Goel, Willie, T,22656 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Mr., Sazanovich, Vadim,14847 | 6725.57 | 0.00 | 3578.27 | 0.00 | 3147.30 |
| Lopez, Samuel, L,26858 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Randall, Mayra,27909 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Deng, Julie,25631 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ruiz, Erika, J,19192 | 1682.41 | 0.00 | 0.00 | 1000.44 | 681.97 |
| Nicholls, Jay, K,17813 | 3020.30 | 0.00 | 0.00 | 2443.35 | 576.95 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gao, Marshall,25782 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Garcia, Kristopher, M,19070 | 4748.33 | 0.00 | 0.00 | 2443.35 | 2304.98 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Schmidt, Mayra,17884 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ye, Eugene, E,11609 | 6872.11 | 0.00 | 2049.10 | 0.00 | 4823.01 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Perry, Hailey, G,20721 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chander, Kelli,26934 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Goel, Kara,16465 | 3271.79 | 0.00 | 0.00 | 2443.35 | 828.44 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Zhu, Laura, M,29439 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chander, Colin, P,12847 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
Generated 2025-12-21 17:11:28.087 UTC