[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 81 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bryant, Sydney, S,11412 | 9879.96 | 0.00 | 3374.99 | 0.00 | 6504.97 |
| Baker, Julia,24650 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Nath, Roger,19383 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Diaz, Antonio,13094 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Goldberg, Keith, A,20961 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Wang, Luke,28856 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Srini, Toni,23072 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Carter, Samuel,26455 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Jackson, Grace, C,15006 | 2994.09 | 0.00 | 699.10 | 0.00 | 2294.99 |
| Fernandez, Martin, D,28645 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Moreno, Audrey,14802 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Perry, Spencer,23808 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Brooks, Chase, A,22764 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Parker, Jose, B,21713 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Coleman, Maria, D,17827 | 2755.42 | 0.00 | 0.00 | 1000.44 | 1754.98 |
| Smith, Michael,23788 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Shen, Johnny,19330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Brown, Eduardo, J,22070 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Munoz, Ricky,16901 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bryant, Trevor,11090 | 6704.08 | 0.00 | 3578.27 | 2374.47 | 751.34 |
| Russell, Elizabeth, A,26624 | 2826.44 | 0.00 | 0.00 | 2049.10 | 777.34 |
| Xu, Drew,20831 | 2012.95 | 0.00 | 0.00 | 782.99 | 1229.96 |
| Collins, Savannah,15164 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Adrienne, M,18132 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
Generated 2025-12-24 05:57:53.445 UTC