[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Raji, April, L,14981 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Black, Nina, L,17968 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 42.28 | 27.96 |
| Andersen, Nichole,12653 | 6860.09 | 0.00 | 0.00 | 2049.10 | 4810.99 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 130.56 | 195.27 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 33.98 | 14.98 |
| Hernandez, Ruben, C,21036 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Malhotra, Roy, P,23220 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Fernandez, Meagan, C,19448 | 3543.88 | 0.00 | 0.00 | 3543.88 | 0.00 |
| Ramos, Janet, B,20596 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Raje, Omar, R,12309 | 102.26 | 0.00 | 0.00 | 0.00 | 102.26 |
| Dominguez, Lori,12648 | 6817.60 | 0.00 | 0.00 | 2049.10 | 4768.50 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Vance, Marie, W,21012 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Kumar, Raul, B,12857 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Munoz, Walter,21056 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| She, Ramon,18000 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Jenkins, Spencer, S,14862 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Mr., Shridhar, Shish,25761 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Huang, Martha, E,26408 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Patel, Kristina,17990 | 2778.52 | 0.00 | 0.00 | 2181.56 | 596.96 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Griffin, Jeremiah,18158 | 6869.61 | 0.00 | 0.00 | 2181.56 | 4688.05 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Gao, Sandra,12594 | 37.98 | 0.00 | 0.00 | 0.00 | 37.98 |
| Samant, Mandar,12873 | 5676.24 | 0.00 | 0.00 | 2071.42 | 3604.82 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Tang, Johnny,15119 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Goel, Latoya, C,11239 | 7511.55 | 3374.99 | 0.00 | 2353.95 | 1782.61 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Diaz, Neil, C,18181 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sun, Willie,19278 | 1575.42 | 0.00 | 1000.44 | 0.00 | 574.98 |
| Zhou, Rosa, D,25573 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
Generated 2025-11-03 14:06:33.565 UTC