[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Tammy, R,20927 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Yang, Rafael, A,23900 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Liang, Jon, R,21042 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanders, Brian, J,18668 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| King, Chloe, W,15269 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Xu, Cassie,24039 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| McDonald, Elijah,18911 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Howard, Dalton,25260 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Hughes, Alexis, B,24081 | 31.28 | 0.00 | 0.00 | 0.00 | 31.28 |
| Robinson, Andrew, J,13745 | 3282.81 | 0.00 | 0.00 | 3282.81 | 0.00 |
| Martin, Christopher, B,28017 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Clark, Hunter, S,11936 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Subram, Patricia,13775 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Muñoz, Hector,14828 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Phillips, Evan, J,26286 | 3308.17 | 0.00 | 0.00 | 2049.10 | 1259.07 |
| Robinson, Isabella, P,20641 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Nath, Terrence,21076 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jai, Yolanda, E,23637 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Navarro, Tanya, C,24130 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Henderson, Chloe,24237 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Jiménez, Cheryl,17198 | 7233.36 | 0.00 | 0.00 | 2443.35 | 4790.01 |
| Zhang, Luis, R,16811 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Carter, Jordan,11950 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Sara, Pedro, F,19451 | 1869.58 | 0.00 | 699.10 | 0.00 | 1170.48 |
| Robinson, Anthony, E,26524 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Yang, Leah, J,15186 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Bradley, Paige,20506 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Moreno, Gerald, A,13770 | 2849.96 | 0.00 | 0.00 | 0.00 | 2849.96 |
| Simmons, Cameron, J,16777 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Ramirez, Juan, M,21700 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Bennett, Samantha, S,17096 | 4144.34 | 0.00 | 0.00 | 4144.34 | 0.00 |
| Flores, Jordan,17035 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Moore, Destiny, C,25207 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Young, Ian,20336 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carter, Charles, R,22899 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Walker, Lauren, M,11012 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Powell, Haley,11630 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Peterson, Riley, S,22025 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Tang, Dale, A,25638 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wilson, Morgan, T,28493 | 814.80 | 0.00 | 0.00 | 0.00 | 814.80 |
| Patel, Henry,14180 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Madan, Cesar, E,11608 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Jimenez, Hector,26257 | 82.95 | 0.00 | 0.00 | 0.00 | 82.95 |
| Bryant, Elizabeth,17407 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Russell, Miguel, Z,13098 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Watson, Amanda, A,14358 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Robinson, Nicholas,11174 | 48.56 | 0.00 | 0.00 | 0.00 | 48.56 |
| Henderson, Katherine, C,17421 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Garcia, Emma, D,23019 | 613.45 | 0.00 | 0.00 | 0.00 | 613.45 |
| Brooks, Sebastian,12638 | 38.47 | 0.00 | 0.00 | 0.00 | 38.47 |
| Xu, Brittney, E,26688 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Zhou, Omar, L,24695 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Ramirez, Cody, M,19148 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| West, Jordyn, J,27554 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Mr., Ruggiero, Michael,21867 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Russell, Zachary,18498 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
Generated 2025-12-21 23:16:41.369 UTC