[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Turner, Devin, J,23464 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Patel, Martin, P,19866 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Seth, J,19846 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sai, Ebony, C,16259 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Russell, Abigail, H,21826 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Zhang, Luke,18862 | 2354.47 | 0.00 | 0.00 | 0.00 | 2354.47 |
| Raje, Cassie,29262 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Kelly, Lucas, A,17133 | 2357.28 | 0.00 | 0.00 | 0.00 | 2357.28 |
| Tang, Omar, L,24027 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Barnes, Trevor, J,20369 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Li, Damien, L,20887 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ramirez, Devin,20315 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Diaz, Sydney,29022 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Bennett, Katherine, S,15315 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Ian, R,23029 | 120.46 | 0.00 | 0.00 | 0.00 | 120.46 |
| Taylor, Elizabeth, P,21901 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Nelson, Angel,24279 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Rogers, Dalton, A,22115 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Andersen, Kenneth,21128 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Tang, Misty, A,14248 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Vazquez, Natasha, J,19727 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Patterson, Kevin,21846 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rai, Nicolas, A,14601 | 3076.06 | 0.00 | 699.10 | 0.00 | 2376.96 |
| Perez, Cynthia, A,24536 | 586.97 | 0.00 | 0.00 | 0.00 | 586.97 |
| Morgan, Connie,12778 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Morgan, Amanda, L,14903 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Wright, Jackson,11698 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Carson, Kathryn, L,18537 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Sanders, Shelby, S,27735 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Sanchez, Chase, A,17336 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Patel, Mayra, R,17784 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 |
| Bryant, Melissa,13218 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Gao, Jaclyn,25667 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Suarez, Jimmy, J,20143 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Simmons, Sarah, V,11500 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Flores, Alexandria,17032 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Lal, Brad,16117 | 86.45 | 0.00 | 0.00 | 0.00 | 86.45 |
| Blanco, Dana, L,13773 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Ma, Alan, J,23906 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Ramirez, Zoe, R,11710 | 97.98 | 0.00 | 0.00 | 0.00 | 97.98 |
| Bryant, Ryan, W,25206 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Simmons, Aidan,23456 | 157.27 | 0.00 | 0.00 | 0.00 | 157.27 |
| Brown, James, C,11192 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Alvarez, Billy, A,28179 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Zeng, Shannon, D,24338 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Phillips, Jordan,23179 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Reed, Jennifer, B,24324 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Long, Gavin,13762 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Subram, Emmanuel, C,20795 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| King, Gabriel, V,28122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Munoz, Andy, C,23187 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sai, Tammy,12718 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Foster, Angela,23814 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Green, Nathan, C,17487 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ortega, Erika, P,20878 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Allen, Caleb, M,23383 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Zhang, Wesley, J,24356 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Serrano, Gina,22700 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rubio, Deanna, T,19573 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Simmons, Devin, K,12102 | 5903.19 | 0.00 | 3578.27 | 0.00 | 2324.92 |
Generated 2025-12-22 02:31:24.267 UTC