[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 0.00 | 87.08 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhao, Candice,25640 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Bennett, Gavin,17588 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Flores, Isabella,25161 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Bailey, Taylor, A,16434 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Robinson, Austin, L,17623 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Walker, Taylor,21740 | 131.44 | 0.00 | 0.00 | 0.00 | 131.44 |
| Anderson, Matthew,15257 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Liu, Micah, J,15220 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Huang, Tiffany, L,21723 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Johnsen, Mario, W,26587 | 1920.42 | 0.00 | 0.00 | 782.99 | 1137.43 |
| Ross, Chloe, L,29404 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Gray, Steven, L,14294 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Cai, Clarence, L,22609 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Chander, Terry, G,26127 | 2049.10 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Phillips, Kevin, L,20270 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Martin, Edward, W,28336 | 138.97 | 0.00 | 0.00 | 0.00 | 138.97 |
| Martinez, Edward, A,28999 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Washington, Spencer, P,23499 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| He, Marshall, R,24191 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Butler, Benjamin, C,18972 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Romero, Theodore,23747 | 1142.42 | 0.00 | 0.00 | 0.00 | 1142.42 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 0.00 | 80.11 |
| Xu, Jon, D,16572 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
Generated 2025-12-23 05:00:23.451 UTC