[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 51 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Flores, Haley, M,21482 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Murphy, Garrett,28849 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Bennett, Kelly,29221 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Sai, Mayra, E,20897 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Lal, Dale,12324 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Collins, Fernando, M,25461 | 1775.97 | 0.00 | 0.00 | 0.00 | 1775.97 |
| Anand, April,11180 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Griffin, Ian,16968 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Prasad, Toni,27900 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Gutierrez, Casey,12519 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Hughes, Jackson,27456 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Liang, Suzanne, M,22534 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Roberts, Eric,24926 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gomez, Tyrone, C,23297 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Suarez, Dwayne, J,24490 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Alonso, Bruce, L,20775 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Gray, Megan, W,13178 | 4498.53 | 0.00 | 2181.56 | 0.00 | 2316.97 |
| Liang, Jon, R,21042 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Carter, Mackenzie, M,15845 | 3244.96 | 0.00 | 0.00 | 782.99 | 2461.97 |
| Diaz, Jonathan, K,13190 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Lal, Tonya, B,24108 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Butler, Kaitlyn, O,19286 | 2755.42 | 0.00 | 0.00 | 1000.44 | 1754.98 |
| Hall, Dalton,20544 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Turner, Connor,17008 | 2316.97 | 0.00 | 0.00 | 0.00 | 2316.97 |
| Nelson, Seth,22729 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Rodriguez, Logan, N,15959 | 3117.97 | 0.00 | 0.00 | 782.99 | 2334.98 |
| Baker, Kaitlyn, L,13232 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Suarez, Ebony,26361 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
Generated 2025-12-24 07:17:49.063 UTC