[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Ramos, Erik, M,25312 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Rai, Cedric,22838 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Lopez, Samuel, L,26858 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Hall, Sydney, T,17880 | 39.55 | 0.00 | 0.00 | 0.00 | 39.55 |
| Mitchell, Fernando,17981 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Hernandez, Mason, C,27782 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Rodriguez, Chelsea,12525 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Zhou, Rosa, D,25573 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Lal, Omar, S,19193 | 1609.40 | 0.00 | 0.00 | 1000.44 | 608.96 |
| Shan, Grant,26215 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Rogers, Brianna,22536 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Ortega, Larry, C,18126 | 6945.58 | 0.00 | 0.00 | 2181.56 | 4764.02 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Coleman, Trevor, C,25313 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Romero, Teresa, A,26834 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Deng, Raul, D,16272 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sai, Stanley,13675 | 215.23 | 0.00 | 0.00 | 0.00 | 215.23 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Browning, Carrie, G,19299 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rivera, Katelyn,23948 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Diaz, Deanna, D,17720 | 2790.53 | 0.00 | 0.00 | 2181.56 | 608.97 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Zhang, Alvin,19082 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
Generated 2025-12-24 06:28:48.917 UTC