[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 999 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Chander, Colin, P,12847 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nara, April, E,25721 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Phillips, Gabriel, R,29443 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rodriguez, Janelle,26887 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Coleman, Austin, V,14865 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sanchez, Ruben, S,13688 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Garcia, Arthur, T,29413 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Torres, Julio,22460 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Clark, Marcus, G,27958 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Suarez, Marie,29429 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Liang, Sandra, J,20949 | 154.98 | 0.00 | 0.00 | 0.00 | 154.98 |
| Subram, Mayra, C,28446 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Morgan, Arianna,18155 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Prasad, Cindy, C,26914 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Allen, Miguel, C,11385 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, James, E,20806 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mehta, George, L,20566 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Ortega, Jésus, L,16542 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Barnes, Alexis, J,23935 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suri, Tabitha,27957 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Hu, Jake, L,24576 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Shan, Christine, R,26895 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Lopez, Martin, E,21864 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Serrano, Ricky,27938 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Wang, Christy,19498 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Arun, Evelyn,27842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Nara, Terry,27305 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kim, Carmen,25502 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Lin, Alejandro, L,12563 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Zhang, Alvin,19082 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Srini, Cesar,11563 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
Generated 2025-12-24 08:36:40.563 UTC