[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cai, Tamara,19744 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| He, Margaret,12308 | 9691.00 | 0.00 | 0.00 | 2500.44 | 7190.56 |
| Griffin, Emily,19657 | 756.26 | 0.00 | 0.00 | 0.00 | 756.26 |
| Hill, Jan,23581 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Mitchell, Jeremiah, S,20334 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Russell, Victoria, D,11317 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Roberts, Connor, W,21606 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Robert,24289 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Raje, Shawna, F,19046 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Chandra, Darren,20698 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Rogers, Alex, A,23450 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Russell, Dylan, W,19658 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Liu, Curtis, L,18040 | 193.98 | 0.00 | 0.00 | 0.00 | 193.98 |
| Kelly, Charles, D,24043 | 31.28 | 0.00 | 0.00 | 0.00 | 31.28 |
| Barnes, Eduardo, R,16768 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Paige,28081 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| King, Isaac, C,23692 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Clark, Morgan,21502 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Cox, Garrett, R,17590 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Davis, Benjamin, C,13672 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rogers, Nathaniel, J,18473 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Perry, Lucas, A,19739 | 614.96 | 0.00 | 0.00 | 0.00 | 614.96 |
| Roberts, Mason, D,11176 | 213.33 | 0.00 | 0.00 | 0.00 | 213.33 |
| Suri, Edgar,24443 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Goel, Alison,15452 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Champion, Tommy, J,28909 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alexander, Faith, A,27276 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Morris, Catherine,11188 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Jenkins, Brandon, J,20117 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Wright, Timothy, E,24928 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Henderson, Emma, A,16018 | 89.97 | 0.00 | 0.00 | 89.97 | 0.00 |
| Kelly, Natalie,15774 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Vazquez, Melody,20747 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hill, Bailey, L,25767 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Subram, Molly, C,25586 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Lin, Jon,21096 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Torres, Deanna, E,16994 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Noah, A,18352 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Gao, Vincent, A,17719 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Alan,22835 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Robinson, Miguel,25463 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Martinez, Austin,21292 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Anderson, Julia,21309 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Bennett, Jessica, S,24330 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Garcia, Erick,25317 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Munoz, Ross, B,13768 | 5063.52 | 0.00 | 2181.56 | 0.00 | 2881.96 |
| Brooks, Mason,21142 | 77.92 | 0.00 | 0.00 | 0.00 | 77.92 |
| Collins, Ian,25904 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Johnson, Dalton,21917 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Mitchell, Blake,13705 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Campbell, Ian,26168 | 31.28 | 0.00 | 0.00 | 0.00 | 31.28 |
| Harris, Alyssa, E,24423 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Simmons, Kayla, D,19745 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Clark, Daniel, L,15016 | 1498.58 | 0.00 | 699.10 | 0.00 | 799.48 |
| Patel, Andre, R,16415 | 4930.68 | 0.00 | 0.00 | 2443.35 | 2487.33 |
| Bailey, Julia, I,16641 | 2391.43 | 0.00 | 0.00 | 0.00 | 2391.43 |
Generated 2025-12-24 06:08:01.668 UTC