[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1094 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhou, Barbara,28539 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Suri, George,27336 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Foster, Katherine,16970 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Carlson, Danny,27859 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Hu, Franklin, H,27882 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Moreno, Anne, A,24807 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Rodriguez, Ivan, H,25305 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Baker, Savannah, C,11081 | 104.26 | 0.00 | 0.00 | 0.00 | 104.26 |
| Torres, Jamie,26542 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Wycoff, Pieter,18546 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Lee, Ryan,16055 | 66.44 | 0.00 | 0.00 | 0.00 | 66.44 |
| Andersen, Bradley, A,22698 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Washington, Luis, T,12533 | 271.95 | 0.00 | 0.00 | 72.96 | 198.99 |
| Ross, Aidan, D,11541 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Andersen, Barbara, G,17984 | 6083.17 | 0.00 | 0.00 | 2443.35 | 3639.82 |
| James, Jasmine,17170 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Reed, Destiny,15385 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Muñoz, Hector,14828 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Shan, Jack, T,24819 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Russell, Jocelyn, C,22879 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Jenkins, Seth, J,24153 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Russell, Lucas,21805 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Shan, April, L,11566 | 1006.83 | 0.00 | 0.00 | 250.25 | 756.58 |
| Foster, Melissa,20352 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Scott, Sara, C,19317 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rana, Manuel,21075 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Washington, Melissa,12191 | 245.47 | 0.00 | 0.00 | 0.00 | 245.47 |
| Shan, Edwin,12268 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Collins, Katherine,16973 | 1857.92 | 0.00 | 0.00 | 0.00 | 1857.92 |
| Bryant, Jason,26485 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Blanco, Audrey,12657 | 7384.10 | 0.00 | 0.00 | 2589.09 | 4795.01 |
Generated 2025-12-22 02:42:24.200 UTC