[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Thompson, Morgan, Q,24011 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Romero, Roy, C,20859 | 2508.97 | 0.00 | 0.00 | 782.99 | 1725.98 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Alexander, Riley,22799 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Gao, Martha,13582 | 77.96 | 0.00 | 0.00 | 68.97 | 8.99 |
| Jai, Christy, G,26979 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Jai, Casey, C,22560 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Zhou, Rosa, D,25573 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Deng, Drew, E,17882 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Ortega, Hector, E,16054 | 3759.36 | 0.00 | 2181.56 | 0.00 | 1577.80 |
| Shan, Misty,20868 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Subram, Lydia, F,28549 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 0.00 | 156.94 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Ramos, Kari, D,24702 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 0.00 | 2511.32 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Alvarez, Kristi,12303 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Williams, Abigail, M,16938 | 3110.05 | 0.00 | 0.00 | 2181.56 | 928.49 |
| Subram, Carmen, J,29473 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Williams, Blake,29421 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Jimenez, Lawrence, B,21068 | 81.45 | 0.00 | 0.00 | 0.00 | 81.45 |
| She, Karla, T,12215 | 6890.73 | 0.00 | 0.00 | 2071.42 | 4819.31 |
| Andersen, Keith,11612 | 6795.12 | 0.00 | 2049.10 | 0.00 | 4746.02 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Edwards, Julia, M,16200 | 96.95 | 0.00 | 0.00 | 0.00 | 96.95 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
Generated 2025-12-23 09:16:39.817 UTC