[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 70 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Butler, Natalie,26401 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanz, Ebony, I,20711 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Hernandez, Jonathon, F,15699 | 6969.57 | 0.00 | 2181.56 | 0.00 | 4788.01 |
| Goel, Gregory,28712 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Gao, Autumn, W,24085 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Lopez, Cassandra,22308 | 1768.96 | 0.00 | 0.00 | 0.00 | 1768.96 |
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Gill, Paula, W,28524 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gutierrez, Lori,24065 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Alonso, Tanya, K,26942 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramos, Teresa,13689 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 782.99 | 1775.47 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Xu, Derek, M,20824 | 2512.96 | 0.00 | 0.00 | 2512.96 | 0.00 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zhang, Franklin, L,12597 | 53.21 | 0.00 | 0.00 | 0.00 | 53.21 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Dominguez, Natasha,23769 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Xu, Jorge, A,14955 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Arun, Virginia,25655 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Romero, Sheila,20577 | 3080.27 | 0.00 | 782.99 | 0.00 | 2297.28 |
| Russell, Natalie, M,20900 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Subram, Levi,15619 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 0.00 | 2181.56 | 1570.82 |
| Serrano, Kari,26905 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Shen, Derek, T,22586 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Madan, Frederick,16550 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
Generated 2026-01-04 05:13:18.790 UTC