[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 33 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Hu, Curtis, G,27880 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Deng, Tonya, O,17936 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 0.00 | 4714.05 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Raji, Franklin,11400 | 6967.78 | 0.00 | 3374.99 | 2318.96 | 1273.83 |
| Tang, Casey,15046 | 5943.25 | 0.00 | 3578.27 | 0.00 | 2364.98 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Yuan, Bonnie, H,15048 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
Generated 2025-12-23 14:10:30.442 UTC