[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 187 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Casey, C,22560 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Xie, Tommy, J,29425 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Moore, Anna, A,12744 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ye, Eugene, E,11609 | 6872.11 | 0.00 | 2049.10 | 0.00 | 4823.01 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Torres, Nelson, F,25804 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hu, Darryl,24868 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sai, Marie, A,24582 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Serrano, Larry,21516 | 3102.25 | 0.00 | 0.00 | 782.99 | 2319.26 |
| Xie, Colleen, C,12133 | 5830.68 | 0.00 | 0.00 | 2071.42 | 3759.26 |
| Tang, Russell,18632 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Jai, Christy, G,26979 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Li, Curtis, E,13692 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Carlson, Craig, G,17218 | 6907.56 | 0.00 | 0.00 | 2181.56 | 4726.00 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Hernandez, Larry,17840 | 228.96 | 0.00 | 0.00 | 0.00 | 228.96 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Larry, T,13664 | 210.25 | 0.00 | 0.00 | 0.00 | 210.25 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zheng, Jessie, W,18028 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ma, Alisha,17972 | 2791.53 | 0.00 | 0.00 | 2181.56 | 609.97 |
| Alvarez, Kristi,12303 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Lin, Cara,29411 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Malhotra, Ruth, D,16321 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Jimenez, Joe,19071 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Arun, Rachael, J,23976 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suri, Francisco,22828 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 0.00 | 132.98 |
| Bryant, Ian,27319 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Rubio, Rebekah,24699 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Carlson, Jerome, J,21817 | 791.47 | 0.00 | 0.00 | 0.00 | 791.47 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Jimenez, Roy,12334 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Sara, Levi, S,12540 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
Generated 2025-12-24 07:10:20.965 UTC