[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 659 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Adams, Ian, C,29422 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 0.00 | 3558.81 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Torres, Rodney, L,22520 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Subram, Jermaine,28731 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Garcia, Ryan, J,15692 | 8392.30 | 0.00 | 3578.27 | 0.00 | 4814.03 |
| Luo, Arturo,22461 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Madan, Donald, R,27168 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Navarro, Shannon, R,15106 | 8421.28 | 0.00 | 3578.27 | 0.00 | 4843.01 |
| Vazquez, Lance,11376 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 0.00 | 4757.02 |
| Moreno, Derrick, C,18625 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Alvin, R,28878 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ward, Alex, I,14542 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Madan, Edgar, M,27131 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Romero, Diana,17760 | 92.25 | 0.00 | 0.00 | 0.00 | 92.25 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Raman, Tammy,12126 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Serrano, Jonathon, F,23954 | 1178.45 | 0.00 | 0.00 | 0.00 | 1178.45 |
| Jai, Kelsey, J,27837 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| He, Rosa, J,15638 | 5162.37 | 0.00 | 3578.27 | 0.00 | 1584.10 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Lopez, Raymond, G,27317 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rana, Heidi, M,22475 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Howard, Timothy,26356 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Xu, Katie, R,14799 | 162.95 | 0.00 | 0.00 | 0.00 | 162.95 |
| Parker, Wyatt,25325 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Martinez, Donald, D,25482 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 0.00 | 76.94 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Parker, Eric, H,27130 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Madan, Dominic, F,21847 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Martinez, Francisco,11375 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-23 07:21:34.583 UTC