[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Morgan,11637 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| Alexander, Isabella,27555 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Morris, Alex,26550 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 0.00 | 4757.02 |
| Rogers, Zoe,28578 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Luis,24294 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 |
| Hernandez, Evan, G,11704 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Suri, Heidi,18480 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Lu, Dawn, G,27833 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Gao, Ernest,27828 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Zeng, Jessie,25091 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Wang, Cedric,19028 | 3063.06 | 0.00 | 699.10 | 0.00 | 2363.96 |
| Phillips, Noah,28144 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Anderson, Jacob, V,19452 | 1611.46 | 0.00 | 0.00 | 782.99 | 828.47 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Cook, Christina,25517 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Amanda, A,18990 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| James, Melanie, V,17546 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Foster, Jason, A,12934 | 4551.53 | 0.00 | 2181.56 | 0.00 | 2369.97 |
| Patterson, Caroline, A,18453 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Bryant, Edward, L,23782 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Moore, Megan, I,23189 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Coleman, Isabella, D,27136 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Wang, Sandra,24878 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-12-23 17:09:34.247 UTC