[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 58 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Murphy, Megan, L,17460 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Taylor, Benjamin,11727 | 5962.24 | 0.00 | 3578.27 | 0.00 | 2383.97 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Alexander, Isabelle, L,15992 | 3194.93 | 0.00 | 0.00 | 782.99 | 2411.94 |
| Thompson, Jonathan,27017 | 4502.14 | 0.00 | 0.00 | 2049.10 | 2453.04 |
| Lopez, Sydney,13073 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Kelly, Erin, D,23513 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Walker, Blake, R,26291 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Yang, Claudia,24556 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Deng, Louis, D,22369 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| King, Natalie, L,26675 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gray, Devin,16584 | 172.95 | 0.00 | 0.00 | 0.00 | 172.95 |
| Perry, Sarah, M,19407 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ma, Mandy,19344 | 186.28 | 0.00 | 0.00 | 186.28 | 0.00 |
| Tang, Keith,17901 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Diaz, Ian, D,11689 | 88.99 | 0.00 | 0.00 | 0.00 | 88.99 |
| Rivera, Mason, M,20473 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Vance, Douglas,16387 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Rodriguez, Cameron, L,11301 | 131.26 | 0.00 | 0.00 | 0.00 | 131.26 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Stewart, Makayla,16649 | 115.94 | 0.00 | 0.00 | 0.00 | 115.94 |
| Alvarez, Wendy, V,12129 | 8557.41 | 0.00 | 0.00 | 2071.42 | 6485.99 |
| Blanco, Neil,19934 | 193.44 | 0.00 | 0.00 | 0.00 | 193.44 |
| Shan, Jose,20843 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Gonzalez, Samuel, L,28143 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Tang, Lindsay, P,24934 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
Generated 2025-12-23 06:05:08.243 UTC