[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Carly,22915 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Moore, Ryan,26458 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Bailey, Maria, C,19150 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Bell, Arianna, M,27675 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Cooper, Catherine, A,12953 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Lewis, Alexandra,24795 | 2507.03 | 0.00 | 0.00 | 0.00 | 2507.03 |
| Chander, Johnny,27935 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Sharma, Jose, R,13244 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| Foster, Benjamin, D,27680 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Stewart, Maria, D,20080 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Gonzales, Eduardo, C,19665 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 0.00 | 192.34 |
| Alexander, Oscar, M,13305 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Coleman, Edward, A,20472 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Robinson, Anthony, E,26524 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Hayes, Hunter,26579 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| Jimenez, Kendra,21287 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Hughes, Julian, S,11722 | 153.46 | 0.00 | 0.00 | 0.00 | 153.46 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Alexander, Jessica, K,11780 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Raman, Regina,19363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Gabriella,12155 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Carter, Nathan,24948 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Zhao, Jon,28148 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Gutierrez, Danny, L,16052 | 2731.54 | 0.00 | 0.00 | 2181.56 | 549.98 |
Generated 2025-12-22 06:45:40.537 UTC