[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 43 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Ramos, Jamie, L,27852 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Martinez, Michele, L,19247 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Vance, Martin, A,25604 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Bryant, Marissa, A,28892 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Kumar, Grant, A,25510 | 1212.95 | 0.00 | 0.00 | 0.00 | 1212.95 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Ye, Sandra,24689 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Suarez, Kendra,23615 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Chen, Jessie,24069 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Vazquez, Lance,11376 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Huang, Todd,12463 | 5202.22 | 0.00 | 0.00 | 2071.42 | 3130.80 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Coleman, Gabriel, B,17706 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Suri, Tabitha,27957 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Andersen, Clayton,15631 | 5122.39 | 0.00 | 3578.27 | 0.00 | 1544.12 |
| Henderson, Tristan,12224 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Lal, Omar, S,19193 | 1609.40 | 0.00 | 0.00 | 1000.44 | 608.96 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Baker, Mackenzie,16563 | 62.95 | 0.00 | 0.00 | 0.00 | 62.95 |
| Hayes, Emily,19184 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wu, Cedric, E,21025 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Vance, Kaitlin,29383 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suarez, Marie,29429 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 0.00 | 2533.97 | 0.00 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2822.76 | 2316.97 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Nara, Gilbert, O,28425 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Kim, Carmen,25502 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
Generated 2025-12-24 06:11:44.131 UTC