[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 91 > < TAKE 120 >
120 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Regina, A,24192 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zeng, Martha, J,17844 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Rana, Allen, D,19036 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
| Watson, Ian, G,26398 | 1758.95 | 0.00 | 0.00 | 0.00 | 1758.95 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Rodriguez, Janelle,26887 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Russell, Emma, I,21512 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Pal, Damien, M,22566 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Foster, Jordan, M,20807 | 3249.31 | 0.00 | 0.00 | 782.99 | 2466.32 |
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 2443.35 | 589.98 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Ma, Suzanne, A,26947 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Wang, Barbara, M,15652 | 5160.08 | 0.00 | 3578.27 | 0.00 | 1581.81 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Xu, Shaun, N,27804 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Beck, Bradley, L,22388 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Kapoor, Jermaine, A,29368 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rai, Cedric,22838 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Alonso, Francis, J,21738 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Alonso, Tanya, K,26942 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Anand, Alejandro, R,28899 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Chen, Marshall, E,19037 | 4858.34 | 0.00 | 0.00 | 2443.35 | 2414.99 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Wu, Cedric, E,21025 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Bailey, Garrett,19055 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Coleman, Alexis, M,11244 | 7175.75 | 0.00 | 3399.99 | 2354.99 | 1420.77 |
| Mrs., West, Alyssa,23219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Arun, Heidi, Z,20149 | 3165.42 | 0.00 | 699.10 | 0.00 | 2466.32 |
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Rubio, Jamie, W,27179 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| He, Rosa, J,15638 | 5162.37 | 0.00 | 3578.27 | 0.00 | 1584.10 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Wang, Christy,19498 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Raje, Damien, S,25784 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bryant, Alexandra,12598 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Yuan, Bridget,26211 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Moore, Anna, A,12744 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Gonzalez, Geoffrey,11603 | 6767.14 | 0.00 | 2049.10 | 0.00 | 4718.04 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gutierrez, Craig,19049 | 4838.30 | 0.00 | 0.00 | 2443.35 | 2394.95 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Arthur, Ronald, D,14776 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Lin, Vincent, A,28516 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Sharma, Latoya,19260 | 1592.71 | 0.00 | 0.00 | 1000.44 | 592.27 |
| Diaz, Jimmy, D,25474 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Williams, Blake,29421 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Andersen, Nichole,12653 | 6860.09 | 0.00 | 0.00 | 2049.10 | 4810.99 |
| Raje, Yolanda,20852 | 2546.96 | 0.00 | 0.00 | 782.99 | 1763.97 |
| Rana, Cesar, L,19044 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Goel, Tasha, R,19478 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Carlson, Gary, R,24115 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Zhang, Randy,12601 | 55.91 | 0.00 | 0.00 | 0.00 | 55.91 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| _SUM | 3388349.72 | 49631.45 | 559026.83 | 808170.26 | 1971521.18 |
| Gonzalez, Raymond, P,28755 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Sai, Allen, E,27781 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 2071.42 | 2868.97 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Malhotra, Meagan, L,27827 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Perez, Andre,11491 | 8158.01 | 0.00 | 3374.99 | 0.00 | 4783.02 |
| Taylor, Grace,24073 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
Generated 2025-12-23 11:39:57.336 UTC