[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simmons, Nathan, M,11043 | 47.98 | 0.00 | 0.00 | 0.00 | 47.98 |
| Stewart, Bryce, B,14562 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zimmerman, Christy, A,27825 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Kennedy, Sheena,25495 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Jennifer, S,11806 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 |
| Suri, Jay,15687 | 6973.87 | 0.00 | 0.00 | 2181.56 | 4792.31 |
| Alexander, Ian, D,26281 | 3335.24 | 0.00 | 0.00 | 2071.42 | 1263.82 |
| Bryant, Mya, P,26711 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Smith, Jessica, C,20069 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Luo, Clarence, M,28158 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Jenkins, Nicole, W,25076 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Chandra, Ruben,25319 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Foster, Austin, C,14753 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 |
| Alonso, Jay, A,15675 | 7206.38 | 0.00 | 0.00 | 2443.35 | 4763.03 |
| Carter, Blake, E,24698 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Mr., Sánchez, Ken,13512 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Foster, Julia, A,26238 | 3298.94 | 0.00 | 2049.10 | 0.00 | 1249.84 |
| Morgan, Jennifer, L,19891 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Reed, Bailey, L,22069 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Rivera, Nicole,23457 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gonzales, Connor, M,16923 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Zhou, Tamara,24862 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Chander, Derek,16557 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Patel, Jarrod, E,27796 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Roberts, Jordan, M,16800 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| White, Samantha,17561 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Johnston, Julia,15837 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Janet, R,16905 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nath, Bonnie, F,12632 | 10793.27 | 0.00 | 3578.27 | 0.00 | 7215.00 |
| Winston, Isabelle, C,18577 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-23 09:10:57.390 UTC