[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Yuan, Alison, K,24574 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Pal, Karl, S,19187 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Carlson, Linda, J,12609 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Fernandez, Dominic,23630 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Watson, Ian, G,26398 | 1758.95 | 0.00 | 0.00 | 0.00 | 1758.95 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Browning, Marie,26372 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Sandoval, Giraldo, Hierro,22634 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Navarro, Lawrence,27939 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Suri, Michele,18007 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Patel, Denise,20179 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gao, Ernest,27828 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Powell, Christian,19522 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Yang, Luke,28526 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| He, Arturo,29369 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Rai, Sheena,29393 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Gonzales, Emma, P,15681 | 105.56 | 0.00 | 0.00 | 33.98 | 71.58 |
| Martin, Michele, J,27819 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Rai, Darrell, C,26906 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 0.00 | 4714.05 |
| Chander, Lindsey,26949 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Mitchell, Fernando,17981 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 2071.42 | 2868.97 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Madan, Douglas,26971 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 0.00 | 2443.35 | 799.42 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Vance, Marie, W,21012 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Carlson, Erika,16444 | 3271.82 | 0.00 | 0.00 | 2443.35 | 828.47 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
Generated 2025-12-23 11:38:29.481 UTC