[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 9 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Gill, Jill, J,26870 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sanchez, Kari, T,19262 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sanz, Kendra,17753 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Mehta, Ivan, S,26390 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Walker, Sydney, A,19047 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Van, Bryant,13562 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2822.76 | 2316.97 |
| Navarro, Dwayne, H,11615 | 5205.71 | 0.00 | 0.00 | 2848.76 | 2356.95 |
| Ortega, Larry, C,18126 | 6945.58 | 0.00 | 0.00 | 2181.56 | 4764.02 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 0.00 | 2533.97 | 0.00 |
| Prasad, Mayra,11238 | 7542.77 | 3399.99 | 0.00 | 2329.98 | 1812.80 |
| Rana, Cesar, L,19044 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Romero, Robyn, C,27802 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Suri, Henry,21683 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Williams, Blake,29421 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Henderson, Julian, J,15691 | 8341.29 | 0.00 | 3578.27 | 0.00 | 4763.02 |
| Navarro, Gary, E,13561 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Diaz, Jaime, A,17795 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Henderson, Anna,24857 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| Hu, Vincent, F,28372 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Gonzalez, Allen,25572 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ashe, Francisco, W,12335 | 6912.60 | 0.00 | 0.00 | 2049.10 | 4863.50 |
| Arun, Virginia,25655 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Blanco, Max,26360 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Gill, Adrienne,14953 | 202.46 | 0.00 | 0.00 | 0.00 | 202.46 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
Generated 2025-12-22 03:30:15.581 UTC