[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Jenkins, Adam, M,18633 | 2793.50 | 0.00 | 0.00 | 2181.56 | 611.94 |
| Suarez, Larry, D,28694 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Nath, Casey,11616 | 5253.65 | 0.00 | 2071.42 | 784.28 | 2397.95 |
| Ms., Slattengren, Dianne, K.,27928 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zhao, Colleen, L,16407 | 3250.11 | 0.00 | 2443.35 | 0.00 | 806.76 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Sai, Allen, E,27781 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alvarez, Neil, C,22467 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Lee, Jacob,13551 | 5622.92 | 0.00 | 0.00 | 2049.10 | 3573.82 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Xie, Mario,13687 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Ramos, Pedro, P,29416 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 782.99 | 1750.98 | 0.00 |
| Huang, Martha, E,26408 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Goel, Terrence, M,19389 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Kumar, Nichole,23236 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 118.47 | 33.98 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Xie, Carl, R,18136 | 6904.60 | 0.00 | 0.00 | 2181.56 | 4723.04 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rana, Cassandra,13407 | 6904.10 | 0.00 | 0.00 | 2049.10 | 4855.00 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Gonzalez, Arthur, G,28747 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Carlson, Craig, G,17218 | 6907.56 | 0.00 | 0.00 | 2181.56 | 4726.00 |
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
| Navarro, Erika, K,11476 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Coleman, Alexis, M,11244 | 7175.75 | 3399.99 | 0.00 | 3166.31 | 609.45 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Kari, D,24702 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Deng, Carly, E,22452 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Zhou, Claudia, M,11247 | 7131.51 | 3374.99 | 0.00 | 2340.23 | 1416.29 |
| Subram, Sergio,28386 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Lopez, Ronald,17855 | 189.96 | 0.00 | 0.00 | 0.00 | 189.96 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Bailey, Ariana, J,13691 | 5976.74 | 3578.27 | 0.00 | 0.00 | 2398.47 |
| Ye, Ernest, A,22558 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rodriguez, Noah, J,22325 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-11-04 05:50:33.634 UTC