[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 32 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brooks, Chase, A,22764 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Xu, Lacey, A,26736 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| He, Laura, W,24692 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Collins, Hunter,18534 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Ward, Melissa, A,29406 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Murphy, Devin,26245 | 4490.48 | 0.00 | 2071.42 | 0.00 | 2419.06 |
| Zhang, Valerie,17765 | 3926.53 | 0.00 | 0.00 | 2181.56 | 1744.97 |
| Watson, Jeremy, A,19225 | 1218.98 | 0.00 | 0.00 | 1218.98 | 0.00 |
| King, Carlos, M,24519 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Long, Julian,12034 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Phillips, Timothy, W,28798 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Sanchez, Devin, J,14369 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Brown, Ashley, D,25165 | 91.58 | 0.00 | 0.00 | 0.00 | 91.58 |
| Simmons, Abigail,18113 | 2391.96 | 0.00 | 0.00 | 0.00 | 2391.96 |
| Jenkins, Abigail,15473 | 1552.48 | 0.00 | 0.00 | 782.99 | 769.49 |
| Chen, Ryan, E,20646 | 1197.97 | 0.00 | 0.00 | 0.00 | 1197.97 |
| Martin, Benjamin,22769 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Jordan, Bruce, E,12544 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Nelson, Carlos,28977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Patel, Tabitha, R,27931 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzales, Sydney, B,13371 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Brooks, Carlos,14628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Isabel, J,28236 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Malhotra, Jarrod, E,27316 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Taylor, Emily,17169 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Carlos,22190 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Diaz, Cameron,14494 | 1769.93 | 0.00 | 0.00 | 1000.44 | 769.49 |
| Peterson, Charles,18615 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Sara, Martin,22809 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Young, Alex, D,25359 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Generated 2025-12-23 09:11:15.669 UTC