[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 78 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Martin, D,24135 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Anderson, Kayla,14454 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Campbell, Luke,13722 | 3102.80 | 0.00 | 0.00 | 2443.35 | 659.45 |
| Malhotra, Molly,24551 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Barnes, Kelly,25204 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Beck, Colin, R,28256 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| King, Ian,14355 | 1804.92 | 0.00 | 0.00 | 1000.44 | 804.48 |
| Green, Isaac, C,22783 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chandra, Cassandra,19463 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Sara,20788 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Alvarez, Marie,20947 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Collins, Wyatt, J,28295 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Henderson, Eric,13457 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Coleman, Jacqueline, A,17212 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Hughes, Dalton, E,13097 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Perez, José, J,14393 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Walker, Cameron, M,22242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Jai, Nicolas, J,21671 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Diaz, Audrey, H,28509 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Adams, Fernando, S,20374 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Lal, Justin,22357 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Phillips, Eduardo, A,25261 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Hernandez, Derrick,13879 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bell, Jasmine, B,16759 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hernandez, Alfredo, C,22606 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Stewart, Brian,19426 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Beck, Dale, R,24022 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Hernandez, Lucas,16972 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Nath, Peter, K,28441 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Robinson, Thomas, C,26637 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Kapoor, Evelyn, E,14708 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Scott, Kaylee, L,21793 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Clark, Olivia,22081 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Butler, Marcus, V,19886 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Turner, Kevin,26466 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wood, Elizabeth, D,26312 | 2881.74 | 0.00 | 0.00 | 2881.74 | 0.00 |
| Saunders, Melody, R,14835 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| He, Alvin,25490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rana, Holly,19743 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Nath, Bridget, C,19446 | 1560.43 | 0.00 | 0.00 | 782.99 | 777.44 |
| Hayes, Samantha,23377 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Serrano, Ross,19767 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Gonzales, Connor, M,16923 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gray, Dalton,11627 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Hall, Savannah, K,21938 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Price, Victoria, A,21338 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Madan, Janelle, E,13746 | 3250.11 | 0.00 | 0.00 | 3250.11 | 0.00 |
| Rana, Tina, F,15105 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Coleman, Julia,11303 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Shan, David,18680 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Suri, Erick,16635 | 122.41 | 0.00 | 0.00 | 0.00 | 122.41 |
| Murphy, Carlos, A,13275 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Parker, Isaac, C,25164 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Perez, Stanley,15818 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Miller, Morgan, C,11817 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Kapoor, Harold, S,25772 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
Generated 2025-12-24 06:04:08.371 UTC